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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

News Largest data breach revealed - 773m email addresses and 21m passwords published 12
Formula (or code) return the largest number of duplicates in a list. 16
Find Smallest and Largest. 5
Automatic Sorting? 6
picking largest number 4
Largest number 4
Largest number 2 3
Second largest in array of difference in high-low values in cells 6

Back
Top