Use { = { MERGEFIELD "fieldname" } * 100 \# ",0.0%" }
You must use Ctrl+F9 to insert each pair of 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
"Pat" .(donotspam) wrote in message
...
HI! I am trying to format to a % and it is not coming in correctly.
I searched and found this message.
My answer in Excel is 121.9%; however it is merging into my word doc as
1.22%
This is what my field reads: {MERGEFIELD "my field name" * 100 \#
",0.0%"}
I see that you are recommending adding an additional field bracket,
however
when I enter as suggested below, I receive this !Syntax Error, {
How do I add additional brackets? Or better yet, how do I make this work
so that my answer in word is 121.9%
--
Thanks, Pat
"Graham Mayor" wrote:
Did you enter the second enclosing pair of field brackets with CTRL+F9?
{={Mergefield Fieldname} * 100 \# ",0.00%"}
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
Barry Baker wrote:
found that this works \# ",0.00"
But i have tried and tried the % one but cant get that to work