adding a zero

[Szucchari]

Hi all,

my co-worker sent me a file that was originally a csv. I don't have that file, she sent it to me in excel but in the excel for some reason dropped the 0 in the columns if that was the first character in the cell.

Is there anyway that I can add a zero to the beginning of each cell, without having to manually enter them? This sheet is over 4,000 rows.

 

[Joe4]

How many columns do you have, and now many need correcting?
How can you tell which values need a zero added to them (should the all be a certain length)?

 

[GR00007]

If the field is zip code, then format the column using Special --> Zip OR Zip Plus 4.