On Sun, 24 Apr 2022 20:15:15 -0400
Fred James wrote:
> 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 e
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
How are the cells displaying the $ sign formatted? I’m guessing they use the
currency format. There’s probably a way to automatically select currency cells
and change the currency, but that’s outside my expertise. Failing that you
could simply edit the $ settings to use the £ symbol in the corr
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?
W
Den sön 24 apr. 2022 kl 23:35 skrev Dave Howorth :
>
> 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 inst