office xp rounding of the 16th number

K

kevin

When entering a value in office excel xp, when I get to
the 16th value it automatically rounds to zero. How to I
get around this?
 
H

Harlan Grove

When entering a value in office excel xp, when I get to
the 16th value it automatically rounds to zero. How to I
get around this?

You can't. Excel only stores up to 15 decimal digits because that's all the
whole decimal digits that double precision binary arithmetic supports. The only
work-around is to enter such numbers as text by preformatting the entry cells
with Text format.
 
G

Greg Lovern

When entering a value in office excel xp, when I get to
the 16th value it automatically rounds to zero. How to I
get around this?

Hi Kevin,

You can get around that with xlPrecision, my add-in for Excel.
xlPrecision provides additional worksheet functions that let you add,
subtract, multiply, and divide with up to 32,767 significant digits in
Excel instead of just 15. (more math functions coming soon..)

You can read more about xlPrecision, and download the free edition,
at:

http://PrecisionCalc.com

xlPrecision is slower than Excel alone, but that's a moot point when
you're doing something that Excel can't do alone anyway. Also,
xlPrecision is fast enough that you might not notice the speed
difference anyway.


Thanks,

Greg Lovern
http://PrecisionCalc.com
Get Your Numbers Right
 

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

Top