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

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!
>
> Cheers, Dave

     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.

Dan


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