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

Article translations Article translations
Article ID: 930204 - View products that this article applies to.
Expand all | Collapse all

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.
Collapse this tableExpand this table
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: January 4, 2007 - Revision: 1.0
APPLIES TO
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
Keywords: 
kbtshoot kbexpertisebeginner kbprb KB930204

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com