largest number

[mike]

What is the largest number that can be input into Excel?

 

[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)

 

[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