Formatting Cell for EUR Currency

N

Nav

I am trying to format a cell to reflect EUR 12,000. I
have Excel 97, however I am unable to see EUR in the
Format Cell/Number/Currency/Symbol as an option.

Is there a way round this?

Eg Cell A1 = 12,000
It should state EUR 12,000

Thanks in advance for your help.
 
N

Nav

Thanks, has worked.

However I now need one for Japanese Yen, this is not in
the Format Cell/Number/Currency/Symbol (JPY is there, but
not the symbol) as an option either.

I am unable to find it in the downloads.

Thanks again for any help/suggestions.
 
Top