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.