Subject: Excel and the euro sign €.
From: "George Simms"
Date: Sun, 3 Jan 1999 14:30:17 -0000
Lines: 33
X-Newsreader: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID:
Newsgroups: microsoft.public.excel.misc
NNTP-Posting-Host: usern439.uk.uudial.com [193.149.84.218]
Path: lobby01.news.aol.com!newstf02.news.aol.com!portc02.blue.aol.com!howland.erols.net!newspeer.monmouth.com!newsfeed.gamma.ru!Gamma.RU!uppssnewspub03.moswest.msn.net!uppssnewspub05.moswest.msn.net
Hi.
A couple of questions have been asked recently about using the new euro
currency sign € .
Here is some information that I have found out.
If your using Win.98 and have a new keyboard with the sign on it, you have
no problems , the fonts , Arial , Courier new , Times New Roman , MS
Sans Serf all have the sign. If you have Win.98 but the sign is not on
your keyboard, hold down the Alt Gr key and hit key 4 $ or hold down the
Alt key and on the numeric key pad ( num lock on ) type 0128 and release
keys.
=CHAR(128) function will also return the sign, if used with one of the
above fonts.
If you want to use the symbol in a currency format, you will need to alter
one of the existing Custom Formats , say : $#,##0.00_);($#,##0.00) to
€#,##0.00_);(€#,##0.00)
Formatting the cells using this.
For win95 the answer is to upgrade your fonts from Microsoft :
www.microsoft.com/windows/euro.asp
All the Best
George.
Newcastle upon Tyne
England.