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

Hi Dave,

Le 24/04/2022 à 23:26, Dave Howorth a écrit :
> 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!

I'd use a cell style for the currency formatted cells. Thus, changing 
currency symbol would simply summarize as changing the cell style 
format. This sheet would then easily adjust to any other currency you 
see fit.

Of course, this will give you some work to set each and every cell 
style, depending on the number of such formatted cells. (perhaps a 
search and replace would do, I have no time currently to check this, sorry)

HTH,
--
Jean-Francois Nifenecker, Bordeaux

--
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