View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default Euro symbol displays as dollar symbol in Excel

What is your system currency system... it is likely to be Euro...

Mine is $... I changed my currency format in Excel to Euro.. now when I
enter $ it changes to ‚¬ (Euro)

Change your system currency to EURO...

"BrendaM" wrote:


Thanks for your quick response, Sheeloo.
However, Autocorrect doesn't seem to be the problem. Turning the various
options off or on makes no difference to my problem. I checked down the list
just in case, but there are no Euro symbols. Smart tags is disabled too.


"Sheeloo" wrote:

Since you see it then it changes - you may check your autocorrect entries -
there might be one correcting Euro to Dollar.
First just disable autocorrect (Tools-AutoCorrect). If it solves the
problem then look for an entry for Euro symbol.


I cannot seem to get the Euro symbol to display correctly in Excel.
I enter the symbol using either ALT 0128 or the InsertSymbol function, but
as soon as I leave the cell, it displays as $ (which is my default currency).
I'm using Windows XP and Excel 2003. I've tried several fonts, including
Tahoma, Arial and Times New Roman. The GBP symbol and the Yen symbol display
correctly.
A solution would be much appreciated.
Thanks in advance,
Brenda