Merging Excel Data into Word Documents

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tami - 26 Jan 2004 15:28 GMT

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!

Reply to this Message

Cindy M -WordMVP- - 26 Jan 2004 17:30 GMT

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
[quoted text clipped - 8 lines]
> 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 :-)

Reply to this Message