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
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?
=ROUND(A2,0) and format as number with 2 decimal places.
--
David Biddulph

"chris gail" <chris wrote in message
...
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