zip codes as numbers
 

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

zip codes as numbers
 

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

"VS" wrote in message ...
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

zip codes as numbers
 

Try formating the cell receiving the info as text - this
usually works for me when excel tries to make a number
into a date. Click on format, cells, and under the
number tab, choose text. Also, you can try the past
special option under edit
-----Original Message-----
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


.

zip codes as numbers
 

Thanks for the quick response!

"David McRitchie" wrote in message
...
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

"VS" wrote in message
...
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