Trouble printing zipcodes that begin with zero

[Richard Mahan Sr]

I have a list of Names, addresses and zip codes for some reason the zip
codes that begin with a 0 do no print. can anyone help me?

[JRod]

Hi Richard,
try : Format|Cells>Custom and in the field Type, type: "0"0 (in this case,
the zip will start allways with a zero),
or try to format the cell as Text
Regards.

--
JRod
http://EXCELer.blogspot.com

"Richard Mahan Sr" <dmachen35@home.com> escreveu na mensagem
news:OXLdg95yFHA.2072@TK2MSFTNGP14.phx.gbl...
> I have a list of Names, addresses and zip codes for some reason the
> zip codes that begin with a 0 do no print. can anyone help me?
>

[Timothy L]

Select the cell(s), row(s), and/or column(s) with the Zip Code in it.

Click "Format" from the menu bar, then click on "Cells...".

Under Category, click "Special".
Under Type, click "Zip Code".

Click OK.

--
Please post all replies to the newsgroup for the benefit of others.
Requests for assistance by email will NOT be acknowledged!



"Richard Mahan Sr" <dmachen35@home.com> wrote in message news:OXLdg95yFHA.2072@TK2MSFTNGP14.phx.gbl...
> I have a list of Names, addresses and zip codes for some reason the zip
> codes that begin with a 0 do no print. can anyone help me?
>
>

[Richard Mahan Sr]

Thanks so much, the information was very helpful and solved the problem I
was having. now if I could pose another question that is related to my first
question. my addresses were in an excel format and then I used word to make
address labels using the mail merge application. the excel spreadsheet had
the Name, address, City, state and zipcodes in separate columns.however when
I printed the labels the State was missing. I don't know what went wrong.
I'm very new at this. Thanks again





"Richard Mahan Sr" <dmachen35@home.com> wrote in message
news:OXLdg95yFHA.2072@TK2MSFTNGP14.phx.gbl...
> I have a list of Names, addresses and zip codes for some reason the
> zip codes that begin with a 0 do no print. can anyone help me?
>

[David McRitchie]

I would really suggest making text entries instead of numbers
whether you are entering US or international zip codes you
would be more consistent, and as text they would be left justified
automatically.

To fix your existing codes (convert to text values) see
Fix up for 5 digit US zip codes (#fixUSzip5)
http://www.mvps.org/dmcritchie/excel/join.htm#fixUSzip5
---
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

"Richard Mahan Sr" <dmachen35@home.com> wrote in message news:OXLdg95yFHA.2072@TK2MSFTNGP14.phx.gbl...
> I have a list of Names, addresses and zip codes for some reason the zip
> codes that begin with a 0 do no print. can anyone help me?
>
>