IDs with leading zeros
An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
The billing system needs every customer ID as text with exactly five digits, padded with zeros in front: 42 becomes 00042. Fill B2 and B3.
What this exercise teaches
A number cannot keep leading zeros, so the padded ID has to be text. TEXT with a format of zeros does it; =RIGHT("00000"&A2,5) is the version without TEXT.
A hint if you get stuck
TEXT(A2,"00000") shows the number with at least five digits. Each 0 in the format is a digit that is always shown.
Try it now, free, no account needed
Your first 15 exercises on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.
Open this exerciseMore exercises in Text and dates
- Build an email address
- Pull out the domain
- Payment due dates
- Clean up names
- Join the tags
- Digits only
- Days between dates
- Year and month
- Contract end date
- Pay by month end
- Split last name, first name
- Calendar quarter
- Month labels with TEXT
- Mask an account number
- File extension
- Completed years of service
- Working days on a task
- Ship-by dates
- Weekend or weekday
- Days in the month