I created a .csv file from another program that included as one of the columns a zip code. If the zip code starts with a zero, the zero was dropped.
Can anyone tell me how to tell Excel XP to look for a four digit number and add a zero to the front of it if it is four digits?
Something like, If I2 is 4 digits, add a zero to the beginning.
Thanks in advance,
Kent
Can anyone tell me how to tell Excel XP to look for a four digit number and add a zero to the front of it if it is four digits?
Something like, If I2 is 4 digits, add a zero to the beginning.
Thanks in advance,
Kent