Format cell to show numbers in thousands
Sometimes it is useful to round numbers to the nearest 1000 in order to obtain a good looking report. That is, to have many small width columns and get them all on the same page when printing.
Formatting cells to show thousands
- Right click on the cell you want to format
- Select Format cells….
- From Category choose Custom
- In the Type area write #,##0, ;[Red](#,##0,);-
You have now the format you need. Additionally it turns the font red when the cell contains negative numbers.
The drowback of this formatting is that when the numbers are added manually the total may differ from the exact one, as the numbers behind the rounding are hidden away.
Have fun with Excel!