" ¦b¶l¥ó
¤¤¼¶¼g...
"0-0 Wai Wai ^-^" wrote:
"Fred Smith" :
To avoid to problem, use the Round function, as in
=Round(a4-b4,2)

Thanks for your reply. But the solution is not practical
since I need to do so for everything I calculate in Excel.
[....]
I have many different formulas which are baffled by this
strange calculation error. It is tons of rewriting. Oh no!!

Try setting Tools Options Calculation Precision As
Displayed.

Of course, then you might need to adjust the format of
some cells to be sure that they display the needed precision.
This includes "helper" cells, which you might have hidden.

Caveat emptor.

Hi.
Is it possible to set something like it is displayed up to 2 decimal places, but
the precision holds up to 10 decimal places or so?

I don't wish to show all figures up to 10 decminal places. It is just too
clumsy.
And since this setting is global, it is still not preferable.