View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Farmom Farmom is offline
external usenet poster
 
Posts: 2
Default printing zip codes

Will that be a problem for the post office? Do the machines read that? Thanks
for your repsonse!

"Gary''s Student" wrote:

Format the column as Text and enter a single quote (apostrophe) before each
entry:

'08759
rather than
08759
--
Gary's Student


"Farmom" wrote:

I am having trouble printing zip codes on labels. We use Excel in our address
database, I format that column for zip codes, when I merge the data into word
2003 to use in labels, it will not print the "0" when the zip codes starts
with 0. I tried to fix it word when editing the labels, then all the zip
codes start with 0. We have a database of about 4600 addresses and it is
really a pain to add the zero onto the labels of about 60-80 labels, can
anybody help me? I'm sure it is not hard to do, (well, I hope it isn't) but I
just can't figure it out. Thanks for any help.