[Annette]

I am merging an Excel 2007 spreadsheet into Word 2007. The field is
{MERGEFIELD "FTE" * 100 \# "0.00%"} 100% merges as 1%; 67% merges as .67%.
What am I doing wrong?

[Graham Mayor]

You will do better with

{={MERGEFIELD "FTE"} * 100 \# "0.00%"}

See 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



Annette wrote:
I am merging an Excel 2007 spreadsheet into Word 2007. The field is
{MERGEFIELD "FTE" * 100 \# "0.00%"} 100% merges as 1%; 67% merges as
.67%. What am I doing wrong?

[Annette]

now it comes through as {=1%} instead of 100%

"Graham Mayor" wrote:

You will do better with

{={MERGEFIELD "FTE"} * 100 \# "0.00%"}

See 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



Annette wrote:
I am merging an Excel 2007 spreadsheet into Word 2007. The field is
{MERGEFIELD "FTE" * 100 \# "0.00%"} 100% merges as 1%; 67% merges as
.67%. What am I doing wrong?

[Peter Jamieson]

All the {} have to be the special "field code braces" that you can enter
using ctrl-F9, not the ones you can type on the keyboard. You can use
Alt-F9 to reveal/hide the field codes.

Peter Jamieson

http://tips.pjmsn.me.uk

Annette wrote:
now it comes through as {=1%} instead of 100%

"Graham Mayor" wrote:

You will do better with

{={MERGEFIELD "FTE"} * 100 \# "0.00%"}

See 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



Annette wrote:
I am merging an Excel 2007 spreadsheet into Word 2007. The field is
{MERGEFIELD "FTE" * 100 \# "0.00%"} 100% merges as 1%; 67% merges as
.67%. What am I doing wrong?