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

Excel's precision is 15 significant decimal digits. You can use numbers that are much larger, but the precision remains 15 digits.
There are several add-ins available that have more precision, but then you can't use any of the results in the standard Excel
functions.
Here's one:

http://precisioncalc.com:80/

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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