I have 4000+ zipcodes in a .csv file that I have imported to excel.

The .csv file shows all zipcodes that start with 0 as a for digit number instead of 5. I need to add the 0 infront of the four that show up.

for example

19601 fills in correctly
08054 shows as 8054

I need an if then statement that basically says if 4 digits then add a 0 infront is 5 digits remain the same.