| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Dropping Leading Zeroes
Using Excel 2007 and Word 2007, I created a mail list in Excel formatting the
5-digit zipcodes as ZIPCODES and the 9-digit zipcodes as ZIPCODE+4. When I previewed and printed the merged data, I saw the zipcodes with a leading zero had the zero truncated (ie 02035 printed as 2035) and the 9-digit zipcode printed as a 0. I temporarily resolved the problem by changing all 0-prefixed zipcodes with '0 to make it a text field. I defined the 9-digit field as TEXT also. Anyone else encounter this problem? Any suggestions how I can fix this? Thanks in advance for any advice given.. -- Bob B |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Leading Zeroes | Tables | |||
| My zip code field on the mail merge drops leading zeroes, why? | Mailmerge | |||
| dropping leading zeros in mail merge | Mailmerge | |||
| Mail Merge dropping leading zeroes from the zip code | Mailmerge | |||
| Mail Merge Dropping leading zeros | Mailmerge | |||
Threaded Mode