zip codes as numbers

V

VS

Hello,
I'm populating each Excel cell with data from a different database that has
addresses in it.
Zip codes that look like '01234' get interpreted as a number and the 0 gets
dropped.

How do I get the cell to read and enter the zip code into the cell as a
string?
Thanks,
V
 
V

VS

Thanks for the quick response!

David McRitchie said:
To convert the numeric ones to text see macro FixUSzip5
http://www.mvps.org/dmcritchie/excel/join.htm#fixuszip5

If you then want to do mail merge, to print labels, I have a page on that
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Hello,
I'm populating each Excel cell with data from a different database that has
addresses in it.
Zip codes that look like '01234' get interpreted as a number and the 0 gets
dropped.

How do I get the cell to read and enter the zip code into the cell as a
string?
Thanks,
V
Click to expand...
Click to expand...
 
Top