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