Chapter 3: Dates and odd displays
Exercise 13: Fix the #### display
Task
The amounts show as ####. Make the numbers visible.
Moves 0 (target 1)5 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 | Amount | |
| 2 | Sales | ##### | |
| 3 | Cost | ##### | |
| 4 | Expenses | ##### | |
| 5 | Profit | ##### | |
| 6 | |||
| 7 |
The amounts show as ####. Make the numbers visible.
This drill is for computer screens. On a phone you can review the steps.
- Select a cell in column B
- Home > Format > AutoFit Column Width (Alt → H → O → I)
Key takeaway
#### isn't an error. It means the column is too narrow.
See custom number formats for details.