On 4/24/22 5:26 PM, Dave Howorth wrote:
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!
Try this: select the columns that contained the currency amounts.
Then right click on one of them making sure that all of them are
selected. Select "Format cells". When the dialog appear, look for the
language setting. Change it from English(USA) to English(UK). Make sure
the the Category is what you want it as well as the Format. Click OK,
and save the spreadsheet.
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Impressum (Legal Info)
: 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