The use of field switches to achieve (2) is detailed at
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




Suzanne S. Barnhill wrote:
This is Word 2002 or 2003? In these versions Word connects to the data
source using OLEDB (which doesn't preserve number formatting) instead
of DDE. You have two options:

1. On the General tab of Tools | Options, check the box for "Confirm
conversions at Open." With that setting enabled, when you connect to
your data source you'll be given the option to choose your connection
method, and you can opt for DDE.

2. You can add a numeric picture switch to the merge field (see
Word's Help under "Numeric picture switch"). Note, however, that you
will have to perform some arithmetic to convert a decimal fraction to
a percentage in addition to adding the number formatting.


"Jerry Ray" Jerry wrote in message
...
I have formatted cells in excell to percent (0%), but when I mail
merge, they are showing up as unending decimals.