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

<!--
/* Font Definitions */
@font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        font-size:11.0pt;
        font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
.MsoChpDefault
        {mso-style-type:export-only;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
        {page:WordSection1;}
-->
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.


&nbsp;


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


</p>
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 <fredjame@fredjame.net> 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 $


> > everywhere!


&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


> that.




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




> Regards


> Fred James




PS Please reply to the list, not to me.




--


To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org


Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/</p>
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette


List archive: https://listarchives.libreoffice.org/global/users/


Privacy Policy: https://www.documentfoundation.org/privacy


&nbsp;



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