Thread: How do I round off a number to 333.00 instead of 332.84?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
מיכאל (מיקי) אבידן מיכאל (מיקי) אבידן is offline
external usenet poster
  
Posts: 561
Default How do I round off a number to 333.00 instead of 332.84?
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!?!
Reply With QuoteReply With Quote