Work with the example
How do you display Pack-007 while keeping the source as numeric 7? A5:A7 contain 7,42,105. B validates nonnegative whole numbers, then uses "Pack-"&TEXT(A5;"000"). C shows whether each source is actually numeric.
| Numeric source | Display |
|---|---|
| 7 | Pack-007 |
| 42 | Pack-042 |
| 105 | Pack-105 |
Edit the working cells
Change A5 to numeric 9: Pack-009. A fresh 1000 gives Pack-1000 in full. Text "007" returns Sequence not numeric; a negative or fractional number returns Sequence must be a whole number. These messages describe the stated exercise input condition.
Check the failure case
Plain concatenation "Pack-"&A5 gives Pack-7. TEXT supplies a display minimum, not a maximum of three digits, and cannot recover an imported identifier whose leading zeros were lost.
Should an imported text ID "007" be converted to 7 to pass this exercise?
Show the worked answer
No. The exercise is for a stated numeric sequence; preserving identity strings is a separate task.