Precision as displayed means that what you see is where excel stops
calculating... hopefully you have a backup of the file from before you turned
that on or can recalculate the results with it off!

The way to display all 30 digits of precision is to format the cells as a
number with 30 as the number of digits.

Select the cell or range of cells, press CTRL+1, go to the number tab,
choose 'number' from the list and change the decimal places box to 30.

"ACRhyne" wrote:

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?