You are currently offline, waiting for your internet to reconnect

Number of significant digits MS Excel retains

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. TheGeneral number format displays up to 11 numeric characters, with thedecimal point counting as a numeric character. Therefore, if the numbercontains a decimal point, Excel can display up to 10 significant digits,but if the number does not contain a decimal point, Excel can display upto 11 significant digits Adding more numbers to the left of the decimalpoint causes the number to appear in exponential notation.
xl2000 xl2002 xl2001 XL97 XL98 precision limit limitation truncate
Properties

Article ID: 65903 - Last Review: 09/19/2011 00:22:00 - Revision: 4.0

  • Microsoft Excel X for Mac
  • Microsoft Excel 2004 for Mac
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2001 for Mac
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 98 for Macintosh
  • Microsoft Excel 97 Standard Edition
  • kbhowto KB65903
Feedback