XL: Custom Scientific Number Format Displayed Incorrectly

 Last reviewed: February 2, 1998
Article ID: Q137263

The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition
  • Microsoft Excel 97 for Windows
  • Microsoft Excel for Windows 95, versions 7.0, 7.0a
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SYMPTOMS

In Microsoft Excel, when you create custom scientific number formats, you may experience unexpected results.

STATUS

Microsoft has confirmed this to be a problem in the versions of Microsoft Excel mentioned at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

The default Scientific number format included in Microsoft Excel is "0.00E+00". This format shows one number before the decimal point and two numbers after. If you create a custom scientific number format that has more than one place indicator before the decimal point, the numbers before the decimal point may not appear as you would expect.

For example, the following table shows a number, how the number will be displayed in Microsoft Excel with the "0.00E+00" format code, how the number will be displayed with the "00.00E+00" format code, and how you might expect it to be displayed with the "00.00E+00" format code. 

                      0.00E+00      00.00E+00      00.00E+00
       Number          Actual        Actual        Expected
     -------------------------------------------------------

     0.00000245       2.45E-06      02.45E-06      24.5E-07
Earlier versions of Microsoft Excel display the number as shown in the "Expected" column. Depending on the number in the cell and the number of significant digits before the decimal point in the Custom Format Code, the versions of Microsoft Excel listed in this article may or may not show the number as expected.

REFERENCES

Microsoft Excel Version 7.0

For more information about how to create custom number formats in Microsoft Excel, click the Index tab in Microsoft Excel Help, type the following text 

   formatting cells, n
double-click the selected text, then double-click "Create Custom Number Formats."

Microsoft Excel Version 5.0

For more information about how to create custom number formats in Microsoft Excel, click the Index tab in Microsoft Excel Help, type the following text 

   custom number formats
and double-click the selected text.

Additional query words: 5.00 5.00a 5.00c 7.00 7.00a 97 98 XL98 XL97 XL7 XL5
Keywords : xlformula xlui kbualink97
Version : WINDOWS:5.0,5.0c,7.0,7.0a,97; MACINTOSH:5.0,5.0a,98
Platform : MACINTOSH WINDOWS

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: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.