Thread: How do I set up a format to round whole numbers into hundredth?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default How do I set up a format to round whole numbers into hundredth?
To round numbers to the nearest hundred use =ROUND(A1,-2)
Note the negative before the 2
best wishes
--
Bernard Liengme
MVP Excel
http://people.stfx.ca/bliengme

"Efren Llarinas" wrote in message
...

Reply With QuoteReply With Quote