XL5: Number Format Error Opening File or Increasing Decimal

Last reviewed: September 12, 1996
Article ID: Q120409
The information in this article applies to:
  • Microsoft Excel for Windows, version 5.0

SYMPTOMS

When you open a file in Microsoft Excel, you receive the following error message:

   File error. Some number formats may have been lost.

Additionally, when you choose the Increase Decimal or the Decrease Decimal button from the Formatting toolbar to format a value in a cell, you receive the following error message:

   Number format is too long.

CAUSE

You receive these error messages if the Symbol box in the International - Currency Format dialog box is empty. You can locate the International settings by double-clicking the International icon in the Windows Control Panel.

If this box does not contain a value, you receive an error message when you close the dialog box. However, if you type a space in the Symbol box, and then choose OK, the value is accepted, however the space character is then removed, leaving the Symbol box empty.

WORKAROUND

To avoid receiving these error messages, set a value in the Symbol box in the International - Currency Format dialog box. You can do this by using the following steps:

   1. Run the Control Panel, and double-click the International icon.

   2. Under Currency Format, choose the Change button.

   3. In the Symbol box, enter the desired character, (other than a space)
      and choose OK.

   4. In the International dialog box, choose OK.

   5. Close the Control Panel.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel version 5.0c for Windows.

Note that in Microsoft Excel version 5.0c, if there is no Currency Format Symbol set in the Microsoft Windows Control Panel, Microsoft Excel assumes that the symbol is the dollar sign ($) character.


KBCategory: kbother kberrmsg
KBSubcategory:

Additional reference words: 5.00 err msg



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.