Thread: rounding
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Sam Sam is offline
external usenet poster
 
Posts: 699
Default rounding

i have set number format to 2 decimal places...but for the final answer i
want the answer to be rounded off to the nearest whole number with 2 d.p
for eg
anwer 312.78 should appear as 313.00..
if i set the format to no dp i get the answer of 313 but the .00 doesnot
appear then. wht am i suppose to do?
--
Sam