How do I enter very large numbers (1.0E+500)

G

Guest

I'm getting a 'Num' error when my calculated number gets above (1.0E+308).
It works in Lotus, but can't seem to work in Excel
 
J

Jerry W. Lewis

Per Help for "Excel specifications and limits", the "largest number
allowed to be typed into a cell" is 9.99999999999999E307 and the
"largest allowed positive number" (resulting from a formula) is
1.79769313486231E308. The latter limit is specified by the IEEE 754
standard for double precision numbers.

If you don't need to do math with these numbers, you can prefix with a
single quote to force it to be text.

If you do need to do math with such large numbers, you might look at the
xlPrecision Add-In from http://precisioncalc.com/

Jerry
 

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

Forms designer load error. 3
'static ' : ignored on left of 'const double' when no variable isdeclared 5
Very Large Numbers 1
Leading Zero's 1
Access Query problem 1
Windows 10 How do I stop Windows automatically adding a space after punctuation 3
How activate "NUM" thingie? 10
IF(logical_test, may be a number or text 4

Top