Biggest Number in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-48710%22%20slang%3D%22en-US%22%3EBiggest%20Number%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-48710%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20someone%20tell%20us%20what%20is%20the%20biggest%20number%20in%20Excel%3F%3CBR%20%2F%3EI%20have%20read%20some%20articles%20about%20this%20topic%2C%20some%20people%20say%20that%20this%20number%20is%20the%20biggest%3A%3CBR%20%2F%3E9.99999999999999E%2B307%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-48710%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-48712%22%20slang%3D%22en-US%22%3ERe%3A%20Biggest%20Number%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-48712%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Haytham%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20answer%20is%20in%20this%20support%20page%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F78113%2Ffloating-point-arithmetic-may-give-inaccurate-results-in-excel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F78113%2Ffloating-point-arithmetic-may-give-inaccurate-results-in-excel%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EAll%20computers%20have%20a%20maximum%20and%20a%20minimum%20number%20that%20can%20be%20handled.%20Because%20the%20number%20of%20bits%20of%20memory%20in%20which%20the%20number%20is%20stored%20is%20finite%2C%20it%20follows%20that%20the%20maximum%20or%20minimum%20number%20that%20can%20be%20stored%20is%20also%20finite.%20For%20Excel%2C%20the%20maximum%20number%20that%20can%20be%20stored%20is%201.79769313486232E%2B308%20and%20the%20minimum%20positive%20number%20that%20can%20be%20stored%20is%202.2250738585072E-308.%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Trusted Contributor

Can someone tell us what is the biggest number in Excel?
I have read some articles about this topic, some people say that this number is the biggest:
9.99999999999999E+307

3 Replies

Hi Haytham,

 

The answer is in this support page https://support.microsoft.com/en-us/help/78113/floating-point-arithmetic-may-give-inaccurate-results...

 

All computers have a maximum and a minimum number that can be handled. Because the number of bits of memory in which the number is stored is finite, it follows that the maximum or minimum number that can be stored is also finite. For Excel, the maximum number that can be stored is 1.79769313486232E+308 and the minimum positive number that can be stored is 2.2250738585072E-308.

@Surge

excel is 0ne million

 

As per Excel specifications and limits, the largest number is indeed 9.99999999999999E+307 when you enter the number in a cell manually. But within formula calculations largest number is 1.7976931348623158e+308. But you can't enter a number larger than 9.99999999999999E+307.

 

1.png