Use displayed value, not stored value?

[Guest]

Hi,

I found the following in the Help file which I think explains a problem I am
having, but can't find how to make the change it says to make in the last
sentence. Where/how do I make it use the displayed value instead of the
stored value?
Thankyou,
CD

Change the precision of calculations:
When a formula performs calculations, Excel usually uses the values stored
in cells referenced by the formula. For example, if two cells each contain
the value 10.005 and the cells are formatted to display values in currency
format, the value $10.01 is displayed in each cell. If you add the two cells
together, the result is $20.01 because Excel adds the stored values 10.005
and 10.005, not the displayed values. You can change the precision of
calculations so that Excel uses the displayed value instead of the stored
value when it recalculates formulas.

 

[Max]

Where/how do I make it use

the displayed value instead of the stored value?

Try:

Tools > Options > Calculation tab
Under "Workbook options",
Check "Precision as displayed"
Click OK

But note that this change is permanent

From Excel's Help
-------------------------
Change the precision of calculations in a workbook
Caution When you change the precision of the calculations in a workbook by
using the displayed (formatted) values, Microsoft Excel permanently changes
any constant values on the worksheets in the workbook. If you later choose
to calculate with full precision, the original underlying values cannot be
restored.