Home |
Search |
Today's Posts |
#1
|
|||
|
|||
ZIP with decimal added
I read a similar post on this after doing a search, but admit the answer
wasn't clear. The problem: when I do a mail merge into Word from an Excel file, the ZIP field imports with a decimal place and zero afterward (ie: 77449.0). The previous answer from Graham Mayor was this: "You cannot alter the inserted field zip. You must toggle the field to {Mergefield Zip} before adding the switch, then F9 to update - see http://www.gmayor.com/formatting_word_fields.htm" I don't know what "toggle the field" means or how you get to "{mergefield Zip}. What is a "switch"? I did go to the suggested webpage and was still confused. I succeeded in adding the "view field codes" button to my toolbar, but don't know how to use it. Also, I saw nothing on the webpage regarding the decimal problem. Sorry for my ignorance of directions that are probably clear to most, but I could use your additional help. Thanks. |
#2
|
|||
|
|||
Either the Toggle fields item in ToolsOptionsView, or Alt+F9
-- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "SToon63" wrote in message ... I read a similar post on this after doing a search, but admit the answer wasn't clear. The problem: when I do a mail merge into Word from an Excel file, the ZIP field imports with a decimal place and zero afterward (ie: 77449.0). The previous answer from Graham Mayor was this: "You cannot alter the inserted field zip. You must toggle the field to {Mergefield Zip} before adding the switch, then F9 to update - see http://www.gmayor.com/formatting_word_fields.htm" I don't know what "toggle the field" means or how you get to "{mergefield Zip}. What is a "switch"? I did go to the suggested webpage and was still confused. I succeeded in adding the "view field codes" button to my toolbar, but don't know how to use it. Also, I saw nothing on the webpage regarding the decimal problem. Sorry for my ignorance of directions that are probably clear to most, but I could use your additional help. Thanks. |
#3
|
|||
|
|||
Either use the method suggested by Doug, or right click the field and choose
toggle from the options. This will display something like {Mergefield Zip} Where Zip is the name of your field. Change that to read {Mergefield Zip \# "00000" } -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org SToon63 wrote: I read a similar post on this after doing a search, but admit the answer wasn't clear. The problem: when I do a mail merge into Word from an Excel file, the ZIP field imports with a decimal place and zero afterward (ie: 77449.0). The previous answer from Graham Mayor was this: "You cannot alter the inserted field zip. You must toggle the field to {Mergefield Zip} before adding the switch, then F9 to update - see http://www.gmayor.com/formatting_word_fields.htm" I don't know what "toggle the field" means or how you get to "{mergefield Zip}. What is a "switch"? I did go to the suggested webpage and was still confused. I succeeded in adding the "view field codes" button to my toolbar, but don't know how to use it. Also, I saw nothing on the webpage regarding the decimal problem. Sorry for my ignorance of directions that are probably clear to most, but I could use your additional help. Thanks. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round numbers to 2 decimal places when using Word Mail Merge | Mailmerge | |||
Typing a repeating decimal in Word - needs overstrike | Microsoft Word Help | |||
How can I have numbered items line up (justify) at the decimal pl. | Microsoft Word Help | |||
Mailmerge wont see Added Excel Data source Columns | Mailmerge | |||
aligning decimal? | Microsoft Word Help |