Session
5 new from Formatting I. About 1 min.
New
Format cells dialog box
⌃Ctrl+1
The amounts need a custom number format. Open the full set of formatting options for the cell.
Invoice 1042.xlsx
HomeInsertDataBIU$%⊞
B2fx1250
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | Amount | Discount | Due |
| 2 | Hosting | 1250 | 0.125 | 46336 |
| 3 | Support | -300 | 0.05 | 46351 |
| 4 | Total | 950 |
or press Enter