largest number

B

Bob Phillips

15 digits is the most you can input, but 9.99999999999999E+307 is the
largest value a cell can hold.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
J

Jerry W. Lewis

1.79769313486232E+308 is the largest value a cell can hold, but it must
be calculated. 9.99999999999999E+307 is the largest value that can be
entered into a cell. Apparently the interpreter bails without checking
if the value can be held if the exponent is 308.

Jerry
 
Top