How do I merge percentage values from Excel to a Word document wi.

[Rswanz]

When exporting percentage values from Excel to a Word document, the value
displayed in Word is the decimal equivalent of the original percentage value.
How does one maintain Excel format of percentages when exporting to a mail
merged document?

 

[Beth Melton]

Use DDE instead of OLEDB to connect to your Excel data source.

In Word go to Tools/Options/General and turn on "Confirm Conversions
at Open". The select your Excel workbook as your data source again.
When prompted select the DDE option to open your data source.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/