Chapter 2: Number formats
Exercise 6: Use the same number of decimal places
Task
The unit prices have different numbers of decimal places. Add thousands separators and show 1 decimal place.
Moves 0 (target 2)3 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 | Item | Unit price | |
| 2 | A | 120.5 | |
| 3 | B | 98 | |
| 4 | C | 1200.25 | |
| 5 | D | 15.75 | |
| 6 | |||
| 7 |
The unit prices have different numbers of decimal places. Add thousands separators and show 1 decimal place.
This drill is for computer screens. On a phone you can review the steps.
- Select B2:B5
- Home > Comma Style (Alt → H → K)
- Home > Increase Decimal (Alt → H → 0)
- Another way: Ctrl + 1 > Number, set decimal places to 1 and check the 1000 separator
Key takeaway
When the decimal points line up, numbers are easy to compare down the column.
See custom number formats for details.