Microsoft KB Archive/192361

= XL97: Euro Currency Character Is Not Displayed Correctly =

Article ID: 192361

Article Last Modified on 6/11/2002

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q192361



IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry



SYMPTOMS
The euro currency character is not displayed as expected on your worksheet. It appears as a vertical bar or a pipe character instead of the euro character.



CAUSE
This problem occurs when you do any of the following:
 * You switch to Page Break Preview or zoom the worksheet to less than 80%. This percentage may vary depending on the type and size of the font that you are using on the worksheet.

-or-
 * You format the worksheet cell with a font size less than 8 points.



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.

To use the Registry Editor to disable the Small Font substitution, follow these steps.

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

 Close any programs that are running. On the Start menu, click Run. Type regedit in the Open box, and then click OK.  In the Registry Editor, expand the following key:      HKey_CURRENT_USER\Software\Microsoft\Office\8.0\Excel\Microsoft Excel  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 the Registry Editor.</li> Start Microsoft Excel. Note that when you zoom your worksheet to 60%, Excel will not substitute a Small Font and the euro character will appear as expected.</li></ol>

<div class="status_section">

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

<div class="moreinformation_section">

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

http://www.microsoft.com/windows/euro.asp

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

For more information about support for the euro in Microsoft Office 95 and Microsoft Office 97, please visit the following Microsoft Web site:

http://www.microsoft.com/office/

Additional query words: XL97

Keywords: kbbug kbpending KB192361

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.