Excel using dollars instead of sterling
 

Hi all

My currency icon in Excel is inserting a $ rather than £ - how can I change
it ?

Thank you.

Excel using dollars instead of sterling
 

Windows StartConfiguration PanelRegional settings
pane Regional settings
change Currency symbol

HTH
--
AP

"Louise" a écrit dans le message de news:
...
Hi all

My currency icon in Excel is inserting a $ rather than £ - how can I
change
it ?

Thank you.

Excel using dollars instead of sterling
 

Check the Regional; Settings in the control panel.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Louise" wrote in message
...
Hi all

My currency icon in Excel is inserting a $ rather than £ - how can I
change
it ?

Thank you.

Excel using dollars instead of sterling
 

Doh! Thank you.


"Ardus Petus" wrote:

Windows StartConfiguration PanelRegional settings
pane Regional settings
change Currency symbol

HTH
--
AP

"Louise" a écrit dans le message de news:
...
Hi all

My currency icon in Excel is inserting a $ rather than £ - how can I
change
it ?

Thank you.

Excel using dollars instead of sterling
 

I spoke too soon. I've tried what you have suggested below and it still
displays dollars??? can you think of anything else??
THanks again.

"Ardus Petus" wrote:

Windows StartConfiguration PanelRegional settings
pane Regional settings
change Currency symbol

HTH
--
AP

"Louise" a écrit dans le message de news:
...
Hi all

My currency icon in Excel is inserting a $ rather than £ - how can I
change
it ?

Thank you.

Excel using dollars instead of sterling
 

so sorry.......
this problem was actually occurring on somebody else's pc and they said they
checked the regional settings and they were OK.
What they failed to tell me is that it was only happening on that one
workbook.........so I checked the number formatting on the book and it was
set to $!!!
That'll teach me to ask more questions about the problem in future!

Thanks again for your help.
Louise

"Ardus Petus" wrote:

Windows StartConfiguration PanelRegional settings
pane Regional settings
change Currency symbol

HTH
--
AP

"Louise" a écrit dans le message de news:
...
Hi all

My currency icon in Excel is inserting a $ rather than £ - how can I
change
it ?

Thank you.