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.

Number of significant digits MS Excel retains


View products that this article applies to.

Summary

Microsoft Excel retains 15 significant digits. To display all 15 digits, you must use a number format (custom or built-in) other than General. The General number format displays up to 11 numeric characters, with the decimal point counting as a numeric character. Therefore, if the number contains a decimal point, Excel can display up to 10 significant digits, but if the number does not contain a decimal point, Excel can display up to 11 significant digits Adding more numbers to the left of the decimal point causes the number to appear in exponential notation.

↑ Back to the top


Keywords: KB65903, kbhowto

↑ Back to the top

Article Info
Article ID : 65903
Revision : 4
Created on : 9/19/2011
Published on : 9/19/2011
Exists online : False
Views : 571