trying to insert a 0 in front of zipcode

  • Thread starter Thread starter hlander9
  • Start date Start date
H

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
 
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
 
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
 
Back
Top