Pad numbers to a fixed width with leading zeros, e.g. 42 → 00042.
Copy this formula
=TEXT(A2, "00000")TEXT formats a number with a pattern; each 0 forces a digit, so "00000" pads to five digits. The result is text — ideal for IDs, ZIP codes, and SKUs that must keep their length.
=TEXT(42, "00000")→00042Pads 42 to five digits.
Yes — apply a custom number format 00000 instead of TEXT to keep numeric values while showing zeros.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.