XL97: Excel Interprets Euro Values as Text (253822)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
This article was previously published under Q253822

SYMPTOMS

When you type a number followed by the euro currency symbol in a cell, Excel interprets the cell as text.

For example, when you type the following

=1,22
and then press ENTER, the contents of the cell appear left-aligned because Excel interprets the cell as text.

NOTE: To type the euro symbol, press CTRL+ALT+E or ALT+0128.

CAUSE

This problem occurs because Excel does not recognize the euro symbol as a valid currency symbol.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

The Euro

The euro is a new currency that the European Union (EU) introduced on January 1, 1999. Until January 1, 2002, participating countries will continue to use their local currency banknotes and coins, but with fixed exchange rates between the individual currencies. (Note that not all countries that are EU members are planning to participate.) On January 1, 2002, euro banknotes and coins will be introduced.

For more information about support of the euro currency in Microsoft products, go to the following Microsoft Web site:

Microsoft Euro Currency Resource Center

Modification Type:MinorLast Reviewed:10/17/2005
Keywords:kbHotfixServer kbQFE kbbug kbfix kbQFE KB253822
©2004 Microsoft Corporation. All rights reserved.