J
jermsalerms
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.
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.