G
gh
I have a column that has the zip codes in the cells. Some are 5 digit
and some are 9 digit, without the - in them. They were a number stored
as text and I changed them to a number. I formatted them using the
format selection from the popup menu. I used special|zip code + 4.
When I use a formula to put the address, city, state and zip together in
another column the - is missing from the zip code (546789087). Also the
5 digit codes are not formatted correctly. Is there a formula that will
check the code to be 5 or 9 and add the - to 9 digit code? What would
cause the formatted code not to copy?
TIA
and some are 9 digit, without the - in them. They were a number stored
as text and I changed them to a number. I formatted them using the
format selection from the popup menu. I used special|zip code + 4.
When I use a formula to put the address, city, state and zip together in
another column the - is missing from the zip code (546789087). Also the
5 digit codes are not formatted correctly. Is there a formula that will
check the code to be 5 or 9 and add the - to 9 digit code? What would
cause the formatted code not to copy?
TIA