Can I format the cells in Excel that will only provide a 5 digit zip code? In
Excel, I open a database that gives me 5 digit and 9 digit zip codes. When I
go into Word to do mail merge, it can only take the five digit zip codes. Is
there a way to change the 9 digits to 5 digits in Excel or in Word, or is
there a way to allow the 9 digits in mail merges in Word?

Thanks in advance.

Word should have no trouble with the zip+4 or the fact that some records
don't have but 5 digits. (Unless you're using a very old version of Word.)

HTH |:)

"sweet_tart08" wrote:

Can I format the cells in Excel that will only provide a 5 digit zip code? In
Excel, I open a database that gives me 5 digit and 9 digit zip codes. When I
go into Word to do mail merge, it can only take the five digit zip codes. Is
there a way to change the 9 digits to 5 digits in Excel or in Word, or is
there a way to allow the 9 digits in mail merges in Word?

Thanks in advance.