Learn to round numbers in Excel. Rounding numbers in excel is critical in order to make spreadsheets look more professional. I use the following trick on a weekly basis to round to the nearest thousandth place. When dealing with large figures, such as sales dollars, it enables your spreadsheet to become easier to read and comprehend.
Round Number Process
- 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
20,134,151 will be displayed as 20,134. Please note that if you select that cell, the full number will be displayed.
Within the Custom category, you can play around with preexisting templates or create your own.