Feb 25 2017 01:01 AM
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
Feb 25 2017 01:28 AM
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.
Mar 14 2022 09:00 AM
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.
Aug 10 2023 12:56 PM
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.