Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cells formatted to % but in mail merge they are showing as decima.
I have formatted cells in excell to percent (0%), but when I mail merge, they
are showing up as unending decimals. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I eliminate numerous "Mail Merge..." under my tool bar? | Microsoft Word Help | |||
mail merge to MAPI as a PDF attachment | Microsoft Word Help | |||
Mail Merge - Date Format | Microsoft Word Help | |||
Mail merge freeze up | Microsoft Word Help | |||
How do I mail merge when only merge document is shown in tools? | Microsoft Word Help |