Forum Discussion
Haytham Amairah
Feb 25, 2017Silver Contributor
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
SergeiBaklan
Feb 25, 2017Diamond Contributor
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.
Perry960
Mar 14, 2022Copper Contributor
@Surge
excel is 0ne million