Euro currency character is not displayed correctly (217124)

Important This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows registry

CAUSE

This problem occurs when you do one or the other of the following:

You zoom the worksheet to less than 80 percent. This percentage may vary depending on the type and size of the font that you are using on the worksheet.
You format the worksheet cell with a font size less than 8 points. This size may vary depending on the zoom level of the worksheet.

For example, the following table shows the zoom level at which the euro character is displayed incorrectly for a given font size.

Font size (Arial)	Zoom level
4	less than 200%
6	less than 135%
8	less than 100%
10	less than 80%
12	less than 70%

RESOLUTION

When you adjust the zoom ratio of the worksheet to less than 80% (depending on the type and size of font that you are using) or resize the font to less than 8 points, Microsoft Excel switches to using Small Fonts, Smalle.fon, or Smallf.fon, depending on the video driver in use in Microsoft Windows. Currently the Euro font is not supported for font sizes smaller than 8 points. However, you can add a registry entry that will cause Microsoft Excel not to switch to using Small Fonts when zooming the worksheet. Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.To use the Registry Editor to disable the Small Font substitution, follow these steps:

Close any programs that are running.
On the Start menu, click Run. Type regedit in the Open box, and then click OK.
In Registry Editor, expand the following subkey:
HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options
On the Edit menu, point to New, and then click DWORD Value. With New Value #1 selected, type FontSub, and then press ENTER.
On the Edit menu, click Modify. In the Edit DWORD Value dialog box, click Decimal under Base. Type the number 0 (zero) for Value. Click OK and quit Registry Editor.
Start Microsoft Excel.

When you zoom your worksheet to 60%, Excel will not substitute a Small Font and the euro character will appear as expected.

MORE INFORMATION

For more information about the euro character, please visit the following Microsoft Web site:

http://www.microsoft.com/typography/eurosymbolfaq.mspx

This Web page contains information about euro character support and links to other relevant Web pages, including the official European Union Web site.