trying to insert a 0 in front of zipcode
 

Hello, I do not use excel at all so i have no clue!
I have a list of daycares that i want to create mailing labels with...about
700 of them but the problem is my zipcode column there needs to be a zero in
front of all 700 zipcodes how to i insert a zero in front of them without
having to type it into each box? the other question is can i print labels
directly from excel or do i have to go thru ms word?
thanks
Greg

trying to insert a 0 in front of zipcode
 

One of these
1) format the cells with custom format 00000
2) format the cells with Special / Zip Codes
3) format the cells as Text
4) begin all zip codes with an single quote (apostrophe) (will not show in
cell nor will it be printed)

1 and 2 can be applied retroactively - ie to existing entries
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"hlander9" wrote in message
...
Hello, I do not use excel at all so i have no clue!
I have a list of daycares that i want to create mailing labels
with...about
700 of them but the problem is my zipcode column there needs to be a zero
in
front of all 700 zipcodes how to i insert a zero in front of them without
having to type it into each box? the other question is can i print labels
directly from excel or do i have to go thru ms word?
thanks
Greg

trying to insert a 0 in front of zipcode
 

You would be much better of using Word for the mailmerge with Excel as the
source.

You could do it in Excel alone but you can waste a lot of paper and labels
with trial and error printing.

See these sites for help on mailmerge.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm

Note on the leading zeros.

If you simply format to show leading zeros, these will not show up in Word's
mailmerge.

You must re-format in Word using Word's field codes.

You may want to actually add the zeros in Excel.

In an adjacent helper column enter =TEXT(cellref,"00000") where cellref is
first cell in your ZIP CODE column

Drag/copy down as far as you need.

Copy that helper column and Paste SpecialValues on top of your original ZIP
CODE column.


Gord Dibben MS Excel MVP

On Tue, 12 Jan 2010 07:22:01 -0800, hlander9
wrote:

Hello, I do not use excel at all so i have no clue!
I have a list of daycares that i want to create mailing labels with...about
700 of them but the problem is my zipcode column there needs to be a zero in
front of all 700 zipcodes how to i insert a zero in front of them without
having to type it into each box? the other question is can i print labels
directly from excel or do i have to go thru ms word?
thanks
Greg