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

[Judy]

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

[gls858]

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

[David McRitchie]

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" <gls858@yahoo.com> wrote in message news:O9KHk7YBFHA.2392@TK2MSFTNGP14.phx.gbl...
> 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