Chapter 2: Number formats
Exercise 5: Add thousands separators to amounts
Task
The amounts are hard to read. Add a comma every three digits.
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 | |
| 2 | Company A | 1234567 | |
| 3 | Company B | 856000 | |
| 4 | Company C | 2300500 | |
| 5 | Company D | 96000 | |
| 6 | |||
| 7 |
The amounts are hard to read. Add a comma every three digits.
This drill is for computer screens. On a phone you can review the steps.
- Select B2:B5
- Home > Comma Style (Alt → H → K)
Key takeaway
Comma Style shows 0 as "-". The cell values don't change.
See custom number formats for details.