Course
TEXT function practice exercises
Five exercises, from a ZIP code that lost its zero to a monthly sales label. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Exercise 1 of 5
Bring back the leading zero in ZIP codes
The ZIP codes in column C were stored as numbers, so Boston’s 02108 shows as 2108. In D2, use TEXT to turn the number in C2 into the five-digit code 02108.
| Customer | City | ZIP (number) | ZIP code |
| Northwind Foods | Boston | 2108 | |
| Harbor Logistics | Newark | 7102 | |
| Cedar Books | Chicago | 60601 | |
| Maple Dental | Hartford | 6103 |