View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
macropod macropod is offline
external usenet poster
 
Posts: 329
Default How Excel to do calculations using more than 12 digits precision?

Hi,

Take a look he
http://digilander.libero.it/foxes/index.htm
This XP add-in claims to be able to give precision up to 250 significant digits. I think you can still find older versions of the
add-in for earlier Excel versions.

Cheers

--
macropod
[MVP - Microsoft Word]


"ACRhyne" wrote in message ...
| I would like to do calculations in my spread sheet with 30 digits precision.
| I figure this is possible because the number display allows 30 digits. I went
| through the help function, and selecting the Precision as Displayed option
| under the Tools, Options, Calculation tab make no difference. Excel still
| rounds off at 12 digits. How do I get higher precision calculations?