Re: [libreoffice-users] changing currency in a spreadsheet

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: users+unsubscribe@global.libreoffice.org
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