Hi, I link my excel table to merge with word. one particular field I want to
show percentage. At excel the data show 5.56%. When I merge with word it show
0%. why? I edit the merge field with this:

{MERGEFIELD "percentage" } * 100\#"0%"}

I try change the type of data at excel using general, number, percentage -
the result is same. pls guide me.

TQ

Your syntax is incorrect - see the example at
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

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


Param wrote:
Hi, I link my excel table to merge with word. one particular field I
want to show percentage. At excel the data show 5.56%. When I merge
with word it show 0%. why? I edit the merge field with this:

{MERGEFIELD "percentage" } * 100\#"0%"}

I try change the type of data at excel using general, number,
percentage - the result is same. pls guide me.

TQ

Yes, I follow as shown on your website, but merge field show syntax error:
!syntax error {

I used:

{ ={MERGEFIELD percentage } * 100 \# "0% "}



"Graham Mayor" wrote:

Your syntax is incorrect - see the example at
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

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


Param wrote:
Hi, I link my excel table to merge with word. one particular field I
want to show percentage. At excel the data show 5.56%. When I merge
with word it show 0%. why? I edit the merge field with this:

{MERGEFIELD "percentage" } * 100\#"0%"}

I try change the type of data at excel using general, number,
percentage - the result is same. pls guide me.

TQ

Did you use CTRL+F9 to insert the field boundaries?

--

Graham Mayor - Word MVP

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


Param wrote:
Yes, I follow as shown on your website, but merge field show syntax
error: !syntax error {

I used:

{ ={MERGEFIELD percentage } * 100 \# "0% "}



"Graham Mayor" wrote:

Your syntax is incorrect - see the example at
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

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


Param wrote:
Hi, I link my excel table to merge with word. one particular field I
want to show percentage. At excel the data show 5.56%. When I merge
with word it show 0%. why? I edit the merge field with this:

{MERGEFIELD "percentage" } * 100\#"0%"}

I try change the type of data at excel using general, number,
percentage - the result is same. pls guide me.

TQ

thank you, I so for only use Alt+F9, new things for me. Thanks lot. I manage
solve the problem. It works fine.

"Graham Mayor" wrote:

Did you use CTRL+F9 to insert the field boundaries?

--

Graham Mayor - Word MVP

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


Param wrote:
Yes, I follow as shown on your website, but merge field show syntax
error: !syntax error {

I used:

{ ={MERGEFIELD percentage } * 100 \# "0% "}



"Graham Mayor" wrote:

Your syntax is incorrect - see the example at
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

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


Param wrote:
Hi, I link my excel table to merge with word. one particular field I
want to show percentage. At excel the data show 5.56%. When I merge
with word it show 0%. why? I edit the merge field with this:

{MERGEFIELD "percentage" } * 100\#"0%"}

I try change the type of data at excel using general, number,
percentage - the result is same. pls guide me.

TQ