Chapter 2: Number formats
Exercise 10: Add a unit to numbers
Task
Add "pcs" after the stock numbers. Keep the values as numbers so they can still be calculated.
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 | Item | Stock | |
| 2 | Notebook | 120 | |
| 3 | Pen | 1500 | |
| 4 | File | 64 | |
| 5 | Sticky notes | 2300 | |
| 6 | |||
| 7 |
Add "pcs" after the stock numbers. Keep the values as numbers so they can still be calculated.
This drill is for computer screens. On a phone you can review the steps.
- Select B2:B5
- Ctrl + 1 > Number > Custom
- Enter #,##0" pcs" in Type and click OK
Key takeaway
Typing "120 pcs" makes the cell text, so it can't be summed. Add units with the number format.
See custom number formats for details.