Biggest Number in Excel

Silver 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

4 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

 

 

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.

@Sergei Baklan