Show % in Table from Merge

D

Dave

I am using Office 2007 and I am trying to use mailmerge to complete forms and
instead of showing 85.7% it will show 0.857 6999999999459 (or something like
that)
Any help appreciated
 
P

Peter Jamieson

Use alt-F9 to show the underlying MERGEFIELD field e.g.

{ MERGEFIELD mypercentage }

Select that, and press ctrl-F9 to enter a pair of field code braces. You
should see something like

{ { MERGEFIELD mypercentage } }

Then type the rest of the stuff to end up with something like the text
below:

{ ={ MERGEFIELD mypercentage } * 100 \#"0.0%" }

Peter Jamieson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top