5 replies
by amanabala
Hello,
I tried to replicate your issue but I could not. Zipcodes starting with 0 did showup correctly. If you can send the excel and word document, I will try to resolve your issue.
cheers,
Ravi
amanabala@yahoo.com
by misscrf
I figured out how to fix this, now let's see if I can explain the answer. hahahaha.
When you have the merge field in word, you can select it and hit alt+F9. This will show its code, including any "switches" You can look up switches in word help to get an idea of how they work. It look me a while to get the right switch that fixes this.
Here is the example of what I did:
{MERGEFIELD "zip" \#0####}
the switch itself is: \#0####
The rest is the merge field code. If you do this, it will display a number of 5 digits long, and start it with a 0.
Just to be sure, In excel, I formatted the zip field as a custom field, and placed 00000 in the format field.
This worked for me when I tested, so I hope it works for you!
by leighserth
by mslizny
by dklippert
This discussion is closed to new replies.
Trending Software posts
Sort by Trending