What ##### actually means
100%
When a number needs more room than its column has, Excel refuses to show part of it. Half a number would be worse than no number at all, so you get ##### instead. The value underneath is intact.
Text behaves differently: it just spills over into the next cell if that cell is empty. Only numbers get the hash treatment.
Column C is too narrow for the figures in it. Widen it until the numbers appear.
C2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Project | Budget | |||
| 2 | Harbour bridge | ###### | |||
| 3 | Rail depot | ###### | |||
| 4 | Tunnel survey | ###### | |||
| 5 | |||||
| 6 | |||||
| 7 | |||||
| 8 |
Click a cell and type. Enter commits, Tab moves right, F2 edits in place, Ctrl+Z undoes. Drag the small square at the corner of a cell to fill. Ctrl+Enter checks your answer.