Date: prev next · Thread: first prev next last
2022 Archives by date, by thread · List index

/* Font Definitions */
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
        panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
a:link, span.MsoHyperlink
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:72.0pt 72.0pt 72.0pt 72.0pt;}
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 
correct place with the appropriate comma and decimal point settings. That’s a bit clunky though.


If by any chance they are not formatted as currency, but something else, you can probably edit that 
setting to switch the currency symbols. That seems unlikely though since you say this is a 
financial spreadsheet.

Sent fromMailfor Windows

From:Dave HoworthSent:25 April 2022 15:07To:LibreOffice UsersSubject:</b>Re: [libreoffice-users] 
changing currency in a spreadsheet

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


&gt; >

Cheers, Dave 

The $ to £ is merely formatting ...

-> Format -> Cells -> and then under Numbers, and under Category

select Currency ... under Format select "GBP £ English (UK)" ... that

should do it. Unless I am wrong the £ is divided into 100 parts just

like the $, so there shouldn't be any need to alter calculations

<p class=MsoNormal>I don't think that does what I want. I would have to select every cell

that has a $ amount, and no other cells, and apply the £ currency. But

that also might change the other format aspects - commas and number of

figures after the decimal point and so forth.

What I'm looking for is something that I can apply to the whole sheet,

and that just changes $ to £ wherever it occurs.

The exchange rate is another matter, of course, if you need to do


No, it's purely the appearance I'm interested in.


Fred James

PS Please reply to the list, not to me.


To unsubscribe e-mail to:

Posting guidelines + more:

List archive:

Privacy Policy:


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.