Number of significant digits MS Excel retains (65903)
The information in this article applies to:
- Microsoft Excel X for Mac
- Microsoft Excel 2004 for Mac
- Microsoft Excel 2002
- Microsoft Excel 2001 for Mac
- Microsoft Excel 2000
- Microsoft Excel 98 Macintosh Edition
- Microsoft Excel 97 for Windows
This article was previously published under Q65903 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.
| Modification Type: | Major | Last Reviewed: | 2/2/2005 |
|---|
| Keywords: | kbhowto KB65903 |
|---|
|