Merging percentages from Excel to Word

[CEP]

Using XP, when I merge a percentage from Excel into Word,
I get the following: If the number in Excel is 4.5% (.045
formatted as percent), when I merge it to Word, I get
4.999999999999E+. It works fine in Window 98, but not XP.
Does anyone know how to fix this.

 

[Graham Mayor]

You need a switch on the merge field in Word as Word displays the raw
unformatted data from Excel eg

{=({Mergefield fieldname} * 100) \# "#.#%" }

will display 4.5% with one decimal place

See also http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[macropod]

Hi CEP,

Select your mergefield and press Shift-F9 to expand the field code. It
should look something like:
{MERGEFIELD ExcelData}
To fix the problem, add a numeric picture switch like:
\# 0.00%
so that your field look like:
{MERGEFIELD ExcelData \# 0.00%}
Then re-run your mailmerge or press F9 to update the filed display.

Cheers

 

[Suzanne S. Barnhill]

Thanks for that, Graham. I was trying just that last night and missed out
the * 100 bit.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.