January 24th in Basic Help by Excelbud .
Round numbers in excel
Rounding numbers in excel in critical in order to make spreadsheets look professional. I use the following trick on a weekly basis to round to the nearest thousand.
Rounding numbers in excel in critical in order to make spreadsheets look professional. I use the following trick on a weekly basis to round to the nearest thousandth place.
- Select the cells containing the numbers you want to display as thousands.
- Select Format, Cells, and click the Number tab.
- In the Category box select Custom
- In the Type box enter #,##0, and click OK
2,452,145 will be displayed as 2,452. Please note that if you select that cell, the full number will be displayed.
