Merging percentages from Excel to Word

  • Thread starter Thread starter CEP
  • Start date Start date
C

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.
 
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
 
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.
 
Back
Top