Merging Excel Data into Word Documents

[Tami]

I have two columns of Excel data causing problems. Once
is a currency column which shows in the Word document as
38582.33. I would like this field to show as $38,582.33.
I am able to format the Excel view to look this way but it
won't carry the formatting over into the merging of the
data.

The second column is a percentage column. This column is
merging into the Word document as .9023456324235. I would
like this field to show as 90.23%. Again, I am able to
make the Excel view look this way but when it is merged
into Work that formatting is lost again.

Please let me know of any ideas or suggestions. Thanks!

 

[Cindy M -WordMVP-]

Hi Tami,

This must be Word 2002 or 2003? What you describe is a result
of the default method Word uses to connect to the data.
Briefly, you need to either change this, or add formatting
switches to the merge fields.

You'll find more information about this in my website's mail
merge FAQ (Word 2002 section) and on www.gmayor.com

I have two columns of Excel data causing problems. Once
is a currency column which shows in the Word document as
38582.33. I would like this field to show as $38,582.33.
I am able to format the Excel view to look this way but it
won't carry the formatting over into the merging of the
data.

The second column is a percentage column. This column is
merging into the Word document as .9023456324235. I would
like this field to show as 90.23%. Again, I am able to
make the Excel view look this way but when it is merged
into Work that formatting is lost again.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail