Leading Zeros

[SSolano]

Imported names and address from a mailing house.
All zips had leading zeroes before the import.
Now they all appear without.
Attempted to format the cell and find and replace.
Nothing seems to bring back the leading zeros.

Any suggestions?

 

[David McRitchie]

I would format the column as text, so that reentries
will be as text, and then run the macro FIXUSZIP5
http://www.mvps.org/dmcritchie/excel/mailmerg.htm#fixuszip5

If you format as a number the zipcodes will not sort
properly if you have both 5 digit and 9 digit zip codes,
Even if the 9 digit zip codes really are numbers which
isn't very likely.

 

[RagDyer]

<<"Attempted to format the cell ">>

Just what formt did you try to use?

Have you tried selecting the column, and then,
<Format> <Cells> <Special>,
And then choose "Zip Code"

This works whether the numbers are "Text" or "Numbers".
All 4 digit numbers will be prefixed with a zero.

However, if you have 5 and 9 digit codes mixed, this won't work too well,
though you'll still get those leading zeros added to the 4 digit numbers.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Imported names and address from a mailing house.
All zips had leading zeroes before the import.
Now they all appear without.
Attempted to format the cell and find and replace.
Nothing seems to bring back the leading zeros.

Any suggestions?