how to format zip codes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do you format zip codes with a dash and additional numbers so you can
merge them to a word document for example(23838-1101)
 
If you are using the Excel Zip Code Format and Word 2002 or later, you have a
couple of options.

In Word, go to Tools | Ootions | General and make sure Confirm conversion at
open is checked.
Then, when you start the merge, choose MS Excel Spredsheet via DDE (the
wording will be slightly different depending on your Office version--look for
spreadsheets and DDE).

Option 2 would be to format your zipcodes as text in Excel. This would mean
you'd have to put the dashes back in manually or with a helper column and a
formula.

tj
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to format zip codes (23838-1101) for a merge. 1
mail merge will not accept zip codes that start with a zero "label 1
Leading 0 in Mail Merge document 4
Zip Code formatting problem 3
format cells as zip code not working 3
How do I format zip code (9) to use in Word merg doc 1
How to merge Excel address columns when some zips begin with zeros 4
Mailmerge zip codes 2

Back
Top