Mail Merge with %

[Jen]

I am trying to merge Excel data into Word 2003 and am having problems getting
the percents to display properly. Many of the threads here (such as
http://www.microsoft.com/office/com...-office-word&lang=en&cr=US&sloc=en-us&m=1&p=1)
are getting me close to solving the problem, but I'm still not quite there.
If I type MERGEFIELD "Average" *100 /# "##.##%" I get the correct decimal
answer with a percent sign (ie .63%). It seems like it should be a simple
correction to get 63% instead of .63, and any help will be greatly
appreciated.

 

[Peter Jamieson]

Try

{ ={ MERGEFIELD Average }*100 \# "##.##%" }

where each pair of {} is a pair of the special "field braces" you can insert
using ctrl-F9 (and ensure you're using \, not /)

Peter Jamieson

 

[Jen]

Thank you!!! It works perfectly!

Try

{ ={ MERGEFIELD Average }*100 \# "##.##%" }

where each pair of {} is a pair of the special "field braces" you can insert
using ctrl-F9 (and ensure you're using \, not /)

Peter Jamieson