Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formatting percent field using mail merge
I have data in an excel table such as .88 (field named Pct) which I want
displayed in mailmerge as 88%. I found an article on the web which said to do the following: {={MERGEFIELD Pct}*100\#"0%"} This is giving me a syntax error. Can you help? |
#2
|
|||
|
|||
Did you insert the field boundaries with CTRL+F9? Update the field after
making the changes F9 See http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org PamWilhite wrote: I have data in an excel table such as .88 (field named Pct) which I want displayed in mailmerge as 88%. I found an article on the web which said to do the following: {={MERGEFIELD Pct}*100\#"0%"} This is giving me a syntax error. Can you help? |
#3
|
|||
|
|||
Yes I tried using CTRL+F9 but I'm not clear about how to do it. I have read
your tutorial and understand what's needed but I don't know how to make it work! Some attempts are just ignored when I do ALT+F9, some show syntax error when I do ALT+F9. Can you clarify the steps of how to use CTRL+F9? Help... "Graham Mayor" wrote: Did you insert the field boundaries with CTRL+F9? Update the field after making the changes F9 See http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org PamWilhite wrote: I have data in an excel table such as .88 (field named Pct) which I want displayed in mailmerge as 88%. I found an article on the web which said to do the following: {={MERGEFIELD Pct}*100\#"0%"} This is giving me a syntax error. Can you help? |
#4
|
|||
|
|||
CTRL+F9 inserts the field boundaries {}
The resulting field you are trying to achieve is {={MERGEFIELD Pct} * 100 \# "0%"} so type CTRL+F9 then inside the brackets type = then CTRL+F9 again Inside the second set type MERGEFIELD Pct . Move the cursor beyond the field and within the outer brackets type the rest as shown (including the spacing). Then ALT+F9 will toggle the display. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org PamWilhite wrote: Yes I tried using CTRL+F9 but I'm not clear about how to do it. I have read your tutorial and understand what's needed but I don't know how to make it work! Some attempts are just ignored when I do ALT+F9, some show syntax error when I do ALT+F9. Can you clarify the steps of how to use CTRL+F9? Help... "Graham Mayor" wrote: Did you insert the field boundaries with CTRL+F9? Update the field after making the changes F9 See http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org PamWilhite wrote: I have data in an excel table such as .88 (field named Pct) which I want displayed in mailmerge as 88%. I found an article on the web which said to do the following: {={MERGEFIELD Pct}*100\#"0%"} This is giving me a syntax error. Can you help? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge with attachments | Mailmerge | |||
How do I maintain number formatting in a mail merge? | Mailmerge | |||
Switch an image dynamically based on mail merge field - possible? | Mailmerge | |||
Mail Merge Field Stripping | Mailmerge | |||
How do I get a field to self adjust in a mail merge? | Mailmerge |