Show % in Table from Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 12 May 2007 17:06 GMT

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

Reply to this Message

Peter Jamieson - 12 May 2007 17:55 GMT

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

>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

Reply to this Message

Graham Mayor - 13 May 2007 05:40 GMT

See also http://www.gmayor.com/formatting_word_fields.htm

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> 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

Reply to this Message

Rate this thread: