ExcelBanter - How do I set up a format to round whole numbers into hundredth?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I set up a format to round whole numbers into hundredth? (https://www.excelbanter.com/excel-worksheet-functions/235619-how-do-i-set-up-format-round-whole-numbers-into-hundredth.html)

Efren Llarinas[_2_]

How do I set up a format to round whole numbers into hundredth?

Bernard Liengme

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
...

All times are GMT +1. The time now is 08:38 PM.