Loading suggested videos

Excel Guide: Add Zeros Before Numbers in Seconds

Add Zero Before Number In Excel

#data formatting

#number formatting

#spreadsheet techniques

“Quick tutorials, zero fluff. Learn it fast at gif.how.”

Steps to add a zero before numbers in Excel

Step 1: Press Ctrl + A to select your data, then press Ctrl + 1 to open the Format Cells window.
Step 2: Go to the Number tab, choose Custom, then in the Type field, enter "0"# and click OK.

Result: A leading zero will appear before each number in the selected cells.

Tip: For fixed-length numbers (like ZIP codes), use a custom format like "00000" to ensure consistent digit length.

References

1https://www.youtube.com/watch?v=H5LhdfmWuGM

Is this video tutorial up to date?

Your feedback helps us improve our content.

Recommended Tutorials

No video found