Round up down or anywhere
 

I the format menue under currancy there is the number of decimal places that
you could set to 3.

"Dawn Ellis" wrote:

I have to fill in a form for the dreaded tax office. Now this form needs to
be correct only to 2 decimal places, therefore discarding any number after
that without rounding the thrid decimal place up. Is there are format to use
on the whole work book? Also any calculations done with that figure should
only use those 2 decimal places but Excell keeps using the whole figure, can
this be stopped also?