Converted data to labels. The 0 in zip codes does not print
 

I converted my data to labels. I can't get the first 0 in the zip code does
not show or print.

Judy wrote:
I converted my data to labels. I can't get the first 0 in the zip code does
not show or print.

The field need to be formatted as text to get the
leading zero to show. There may be other ways to do it
but this will work.

gls858

Hi Judy,
and if you want to correct existing entries that lost the leading
zero because you didn't have text already turned on, you can
correct them with a macro
http://www.mvps.org/dmcritchie/excel/join.htm#fixUSzip5

If not familiar with installing and using macros the box at the top of that page points to
http://www.mvps.org/dmcritchie/excel/getstarted.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

"gls858" wrote in message ...
Judy wrote:
I converted my data to labels. I can't get the first 0 in the zip code does
not show or print.

The field need to be formatted as text to get the
leading zero to show. There may be other ways to do it
but this will work.

gls858