View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dawn Ellis Dawn Ellis is offline
external usenet poster
 
Posts: 1
Default Round up down or anywhere

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?