Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up a format to round whole numbers into hundredth?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
round numbers in the millions to numbers in the thousands | Excel Worksheet Functions | |||
How do I change percentage function to less than a hundredth? | New Users to Excel | |||
Excel should format time down to the hundredth/sec. | Excel Discussion (Misc queries) | |||
EXCEL - I need to compare times to the hundredth of a second | Setting up and Configuration of Excel | |||
Can you format a whole column of numbers to round? | Excel Worksheet Functions |