Chapter 2: Number formats
Exercise 7: Show amounts in thousands
Task
Show sales in thousands. Don't change the cell values; use only the number format.
Moves 0 (target 1)4 difference(s) from the model
File
Font
Alignment
Number
Styles
Cells
A1Press and release Alt to show KeyTips (Windows). Ctrl + 1 opens Format Cells, Ctrl + Z undoes.
| A | B | C | |
|---|---|---|---|
| 1 | Client | Sales (thousands) | |
| 2 | Company A | 1234567 | |
| 3 | Company B | 856000 | |
| 4 | Company C | 2300500 | |
| 5 | Company D | 96000 | |
| 6 | |||
| 7 |
Show sales in thousands. Don't change the cell values; use only the number format.
This drill is for computer screens. On a phone you can review the steps.
- Select B2:B5
- Press Ctrl + 1 to open Format Cells
- Number > Custom: enter #,##0, in Type and click OK
Key takeaway
One trailing comma hides the last three digits. Totals and other calculations still use the original values.
See custom number formats for details.