Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Losing zipcode when I merge!
Hi-
Can anyone help!?!?! When I merge my excel file to Word the 5 digit zip 02601 (the format in Excel) loses the first number and become 2601. I hve made sure that the cell format is correct in Excel (5 digit zip) but it still drops that first zero. Does anyone know what I should do? Thanks! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Losing zipcode when I merge!
Use Alt-F9 to show the "underlying field codes" in Word, and wehre you have
{ MERGEFIELD "zipcode field" } change it to { MERGEFIELD "zipcode field" \#00000 } (If you have { MERGEFIELD "zipcode field" \*Mergeformat } change it to { MERGEFIELD "zipcode field" \#00000 \*Mergeformat } Peter Jamieson "Anne" wrote in message ... Hi- Can anyone help!?!?! When I merge my excel file to Word the 5 digit zip 02601 (the format in Excel) loses the first number and become 2601. I hve made sure that the cell format is correct in Excel (5 digit zip) but it still drops that first zero. Does anyone know what I should do? Thanks! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MSWordToolsMergeLabels from XLS appends .0 to Zipcode. FIX? | Mailmerge | |||
Losing Mail Merge Items after I perform "Merge Option". | New Users | |||
Losing Mail Merge Items after I perform "Merge Option". | New Users | |||
Losing Mail Merge Items after I perform "Merge Option". | New Users | |||
Losing Mail Merge Items after I perform "Merge Option". | New Users |