how to format zip codes

T

thoffman

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)
 
T

tjtjjtjt

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
 
Top