Forum Discussion
Biggest Number in Excel
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
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.
Hi Haytham,
The answer is in this support page https://support.microsoft.com/en-us/help/78113/floating-point-arithmetic-may-give-inaccurate-results-in-excel
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.
Thanks, Sergei.
I was trying to create a spreadsheet to calculate the ‘Birthday Paradox’, but kept getting the ‘#NUM!’ error, which has a factorial of 365 in it that put it over the limit. It wasn’t until I read your post when I found out why.
@Surge
excel is 0ne million
