| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 16th digit changes?? Problem,16th digit changes to a zero.... | Excel Worksheet Functions | |||
| Return a digit in a string of numbers | Excel Discussion (Misc queries) | |||
| How to find if a string starts with a digit | Excel Worksheet Functions | |||
| Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
| 16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions | |||
Threaded Mode
