Word XP is converting my percentages from Excel from 41% to 0.4135483679 I am
trying to find the correct syntax to format the field. This is what have
been trying
{ ={mergefield amount } *100\#"0%"} I keep getting a syntax error.

Try

{ =({mergefield amount } *100)\# #.00%}

Also you might want to have a look at Graham Mayor's discussion on
merging Excel data he
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

I am still getting "!Syntax, {" error. Actually I found that site before I
posted here. That is where I got my original attempt at formatting the
field. Any thoughts as to why its not working?

"Greg" wrote:

Try

{ =({mergefield amount } *100)\# #.00%}

Also you might want to have a look at Graham Mayor's discussion on
merging Excel data he
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

Try putting a space before the backslash.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Kylor" wrote in message
news
Word XP is converting my percentages from Excel from 41% to 0.4135483679 I
am
trying to find the correct syntax to format the field. This is what have
been trying
{ ={mergefield amount } *100\#"0%"} I keep getting a syntax error.

Thanks but got the same error "!Syntax Error,"

"Suzanne S. Barnhill" wrote:

Try putting a space before the backslash.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Kylor" wrote in message
news
Word XP is converting my percentages from Excel from 41% to 0.4135483679 I
am
trying to find the correct syntax to format the field. This is what have
been trying
{ ={mergefield amount } *100\#"0%"} I keep getting a syntax error.

Kylor,

Are you entering each pair of field code braces with CTRL+F9 ?