Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to format Zip Code from 9 to 5
I hope this makes sense! We have a glitch in our computer software that
automatically places zeros in the place of the zip code plus 4 numbers when there are no numbers there, 75043-0000 or 75043--000 or 75043-000. Since we do not have control over programming we need to overcome this problem, hopefully, by using MS Word. We are okay with not seeing the plus four numbers if they are there, because most often we only get the standard 5 numbers. I have tried different formatting using Bookmarks, and this works if there are only zeros in the plus 4 field, but if there ARE numbers what I get is Word subtracting the plus four and creating a whole new zip code. {IF {ZIP} 99999 "{ ZIP \# "00000'-'0000"}""{ZIP \# "00000"}"} takes this number 75841-1111 and makes it 74730. Is there any way to get Word to just truncate the last four numbers and only show the first five? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My zip code format is lost when merging from Excel to Word... | Microsoft Word Help | |||
My zip code format is lost when merging from Excel to Word... | Microsoft Word Help | |||
My zip code format is lost when merging from Excel to Word... | Microsoft Word Help | |||
Can I format zip code merge field to add hyphen if zip plus 4? | Mailmerge | |||
Mail Merge Zip Code will not format correctly | Mailmerge |