Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi all
My currency icon in Excel is inserting a $ rather than £ - how can I change it ? Thank you. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Adding "and" to Spellnumber code | Excel Discussion (Misc queries) | |||
Currency to Text | Excel Worksheet Functions | |||
Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |