View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default How do I round off a number to 333.00 instead of 332.84?

Wouldn't those give 332 instead of 333, Micky?
--
David Biddulph

"????? (????) ?????" <micky-a*at*tapuz.co.il wrote in message
...
Assuming 332.84 us in cell A1 - try these:
=TRUNC(A1)
=INT(A1)
=ROUNDDOWN(A1,0)
=FLOOR(A1,1)
Micky


"chris gail" wrote:

How do I round off a number to 333.00 instead of 332.84? I need the
decimal
point showing with the zeros after it!?!