office xp rounding of the 16th number

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

 

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

 

[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