XL95: Euro Currency Character Is Not Displayed Correctly

ID: Q216910

The information in this article applies to:

IMPORTANT: This article contains information about editing the registry. Before you edit the registry, make sure you understand how to restore it if a problem occurs. For information about how to do this, view the "Restoring the Registry" Help topic in Regedit.exe or the "Restoring a Registry Key" Help topic in Regedt32.exe.

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:


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.

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

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

For information about how to edit the registry, view the "Changing Keys And Values" Help topic in Registry Editor (Regedit.exe) or the "Add and Delete Information in the Registry" and "Edit Registry Data" Help topics in Regedt32.exe. Note that you should back up the registry before you edit it. If you are running Windows NT, you should also update your Emergency Repair Disk (ERD).

  1. Close any programs that are running.


  2. On the Start menu, click Run. Type regedit in the Open box, and then click OK.


  3. In the Registry Editor, expand the following subkey:


    4. HKey_CURRENT_USER\Software\Microsoft\Excel\7.0\Microsoft Excel
  4. On the Edit menu, point to New, and then click DWORD Value. With "New Value #1" selected, type FontSub, and then press ENTER.


  5. 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.


  6. 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.



STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


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/000/office/documents/euro.htm

Additional query words: xl7 xl95 euro dollar y2k 


Keywords          : kbdta kb2000 xlformat 
Version           : WINDOWS:7.0
Platform          : WINDOWS 
Issue type        : kbinfo

Last Reviewed: March 27, 1999