You are currently offline, waiting for your internet to reconnect

The specifications for the smallest and largest allowed positive and negative numbers are wrong in the Help files for Excel

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

SYMPTOMS
The specifications for the smallest and largest allowed positive and negative numbers are wrong in the Help files for Microsoft Excel.
MORE INFORMATION
To access these specifications in the Excel Help files, follow these steps:
  1. Press F1 to open Excel Help.
  2. Type specifications in the search text box, and then press ENTER.
  3. Click to select the Excel specifications and limits topic in the search results list.
  4. Click Calculation specifications and limits.
The correct specifications are as follows.
FeatureMaximum limit
Smallest allowed positive number2.2251E-308
Smallest allowed negative number-2.2251E-308
Largest number that can be typed into a cell9.99999999999999E+307
Largest allowed positive number 1.7976931348623158e+308
Largest allowed negative number -1.7976931348623158e+308
Properties

Article ID: 930204 - Last Review: 01/04/2007 18:24:01 - Revision: 1.0

  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
  • kbtshoot kbexpertisebeginner kbprb KB930204
Feedback