Increase Excel Precision

  • Thread starter Thread starter Ian B.
  • Start date Start date
I

Ian B.

Is there away of increasing the calculation precision in Excel? Not by too
much, 25 s.f. (possibly 30 later on) is all the precision I need.

TIA,
Ian
 
Is there away of increasing the calculation precision in Excel? Not by too
much, 25 s.f. (possibly 30 later on) is all the precision I need.
Click to expand...

You could try to duplicate all Excel's numeric functionality in VBA using
nothing but variables of type Decimal, but it'd take a long time to do so, and
recalculation would crawl.

Other than this, there's no way to get Excel to use higher precision.
 
J.E. McGimpsey said:
I've never used it, but this add-in claims to extend XL's functions
to 200 digits:

http://digilander.libero.it/foxes/index.htm
Click to expand...

Cheers, works great :-), if a little tricky to get started with.

Recommended for anyone else too, there's a similar product but it's not
free, although it does allow precision up to 32,767 if you need that much.
Works fine with latest XP version of Excel.
 
Back
Top