<!--
/* 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.
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 <[email protected]> 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!
> >
> > 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: [email protected]
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
--
To unsubscribe e-mail to: [email protected]
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
