Hi Dave,
On 2022-04-24 17:26, 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?
When you do "Format Cells" (Ctrl+1) and select "Currency", do you not get a drop-down "Format"
menu that allows designation of the currency of choice? (In fact, if you select a "Language" different from your
default language {Tools > Options > Language Settings > Languages}, it should allow you to select from two different
currencies at the same time.)
Kind regards,
John
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
