largest number

  • Thread starter Thread starter mike
  • Start date Start date
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)
 
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
 
Back
Top