trying to insert a 0 in front of zipcode

[hlander9]

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

 

[Bernard Liengme]

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

 

[Gord Dibben]

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/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.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 Special>Values on top of your original ZIP
CODE column.


Gord Dibben MS Excel MVP