Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Percentage
I have a percent merging from Excel to Word that results in a decimal in the
Word document. My merge field is «Training_Percent» . I've tried doing a field formula { ={ MERGEFIELD Training_Percent} * 100 \# "0%"} as I found on another site, but it's not working. It only results in an error. Can anyone help? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Percentage
Did you use Ctrl+F9 to insert the field delimiters {}?
-- 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 "Mishy" wrote in message ... I have a percent merging from Excel to Word that results in a decimal in the Word document. My merge field is «Training_Percent» . I've tried doing a field formula { ={ MERGEFIELD Training_Percent} * 100 \# "0%"} as I found on another site, but it's not working. It only results in an error. Can anyone help? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Percentage
Hi Mishy
When you added the code for the percentage calculation, you needed to create the field braces (i.e. '{ }') as a pair via Ctrl-F9 - typing them in won't work and will result in a syntax error. If that's what your're getting, recreate the field by pressing Ctrl-F9 twice, so that you get: { { } } then fill in between them so that you end up with: {={MERGEFIELD Training_Percent}*100 \# 0%} making sure to replicate the indicated spacing. If you need your percentage to show with decimals, change the '0%' to '0.0%', for one decimal, '0.00%' for two decimals, and so on. Cheers -- macropod [MVP - Microsoft Word] "Mishy" wrote in message ... | I have a percent merging from Excel to Word that results in a decimal in the | Word document. My merge field is «Training_Percent» . I've tried doing a | field formula { ={ MERGEFIELD Training_Percent} * 100 \# "0%"} as I found on | another site, but it's not working. It only results in an error. Can anyone | help? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Percentage
THANK YOU THANK YOU THANK YOU!!!!
"macropod" wrote: Hi Mishy When you added the code for the percentage calculation, you needed to create the field braces (i.e. '{ }') as a pair via Ctrl-F9 - typing them in won't work and will result in a syntax error. If that's what your're getting, recreate the field by pressing Ctrl-F9 twice, so that you get: { { } } then fill in between them so that you end up with: {={MERGEFIELD Training_Percent}*100 \# 0%} making sure to replicate the indicated spacing. If you need your percentage to show with decimals, change the '0%' to '0.0%', for one decimal, '0.00%' for two decimals, and so on. Cheers -- macropod [MVP - Microsoft Word] "Mishy" wrote in message ... | I have a percent merging from Excel to Word that results in a decimal in the | Word document. My merge field is «Training_Percent» . I've tried doing a | field formula { ={ MERGEFIELD Training_Percent} * 100 \# "0%"} as I found on | another site, but it's not working. It only results in an error. Can anyone | help? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advantage of Mail Merge 2003 over Mail Merge 2000 | Mailmerge | |||
My Email Mail Merge Does Not Work | Mailmerge | |||
Adding a field to an Off 97 mail merge using Office Pro 2003 | Mailmerge | |||
Formatting a percentage mail merge field | Microsoft Word Help | |||
Percentage format is lost when doing a mail merge in Word | Mailmerge |