How can I get mail merge from Excel to word to display calculated.

[Lucy2You]

I have an excel file that I have calculated fields that display as
percentages. When I mail merge to MS word, using numberic picture switches,
the calculated number is wrong and does not display as a percentage. What am
I doing wrong?

 

[Graham Mayor]

You need to use a switch on the mergefield in Word to display the
information you require
You will probably find that

{= {Mergefield fieldname}* 100 \# "# %" }

will give the correct result.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>