Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

XL2000: Custom Scientific Number Format Is Displayed Incorrectly


View products that this article applies to.

Symptoms

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

↑ Back to the top


Status

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

↑ Back to the top


More information

The default scientific number format included in Microsoft Excel is as follows:
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 is displayed in Microsoft Excel with the 0.00E+00 format code, how the number is 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
				
Versions of Microsoft Excel earlier than Microsoft Excel version 5.0 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, Microsoft Excel 2000 may or may not show the number as expected.

↑ Back to the top


References

For more information about creating custom number formats, click Microsoft Excel Help on the Help menu, type create a custom number format in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

↑ Back to the top


Keywords: KB214273, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 214273
Revision : 4
Created on : 9/27/2003
Published on : 9/27/2003
Exists online : False
Views : 251