Date: prev next · Thread: first prev next last
2022 Archives by date, by thread · List index

Den sön 24 apr. 2022 kl 23:35 skrev Dave Howorth <>:

I have a financial spreadsheet that was designed in the USA but I live
in the UK. Is there any way in LO to change all the cells that are
formatted as numeric $ amounts to be the same format but using the
equivalent numeric £ format instead?

I don't think there's any logic in the spreadsheet that depends on the
currency, it's just doing numerical calculations on the values. But it
would be easier to look at if it was in £ rather than $ everywhere!

Cheers, Dave

If you are lucky (probably not, but let's give it a go, at least), your
spreadsheet was done properly to begin with. That means that styles were
used properly, so in every cell where a currency is used, they used the
same style. If so, then just find out which style that is and change the
currency format in that style, and BAM, all of your currency cells are
corrected at once!

THIS is why you should use styles. If you don't, start doing it now. It's
maybe a bit slower in the beginning, but you don't have to setup your
styles that thoroughly immediately, you can do that later, just make sure
that every cell that is formatted differently is using a style for that.
Then you can always modify that style later and affect thousands of cells
spread over a whole lot of sheets (within that file, of course) at once.
Very, very useful, I can't stress that enough.

So, let's say that the creator of your document didn't care about styles,
which probably is the case. Then highlight all cells with currency (you can
highlight whole columns with just one click and you can highlight more than
one column at a time using the shift key while clicking a column and so
on), hit Ctrl+m to strip all those cells from any kind of formatting
(except conditional formatting, I think, but not sure about that) and then
apply a style to them. Don't forget to name that style properly if you
create a new one, making it easier for you in the future to figure out what
the heck you were doing all those years ago.

Then you can easily modify that style as you wish and you can play with
that forever if you want to. Maybe tomorrow you want all currencies to be
in a smaller font. Well, edit that style again, pick a smaller font, and
BAM, thousands of cells are immediately affected. If you want to apply that
style to more cells, just select those cells and click that style.

Kind regards

Johnny Rosenberg

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.