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

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.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"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.

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.

Thanks, Graham. I keep forgetting about that article.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Graham Mayor" wrote in message
...
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.