only 5 digit zip codes
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. |
All times are GMT +1. The time now is 01:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com