Round Numbers To The Nearest 1000

Round Numbers To The Nearest 1000

Often in Excel, when working with large numbers it is common practice to show numbers as thousands, with a note to that effect shown somewhere on the report. To display your numbers to the nearest thousand in Excel you do not need to change any numbers or do any conversions. You simply change the way the number is displayed by creating a custom number format.

1) Select the cells containing the numbers you want to display as thousands.
2) Select Format, Cells, and click the Number tab.
3) In the Category box select Custom
4) In the Type box enter #,##0, and click OK

The number 5,250,760.95 will now display as 5,251.

Always remember that formatting a number has no effect on its underlying value.


No Responses

Show all responses

Leave a Reply