Do you have a lot of numbers with an uneven number of digits in your Excel list?
Do you want to make them uniform by adding leading zeros to them?
Well, it’s a pain to add zeros in front of them one by one!
Thankfully, Excel allows you to add leading zeros with one single formula!
STEP 1: We need to enter the TEXT function in a blank cell:
STEP 2: The TEXT arguments:
What is the value that you want to add leading zeros on?
How many leading zeros do you need?
If we want our number to be 6 digits long, then type in 6 zeros: “000000”
Apply the same formula to the rest of the cells by dragging the lower right corner downwards. Your leading zeros are now ready!
How to Add Leading Zeros in Excel