Merge Excel Data into Word Document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Webkinz - 20 Sep 2007 23:40 GMT

How do you merge Excel Data into a Word Document and keep the number format.
E.G. 150,000.00. When I merge it merges as 150000

Reply to this Message

David Biddulph - 21 Sep 2007 08:34 GMT

Two ways:
There are apparently field formatting commands available in Word
or
in Excel use =TEXT(A1,"#,##0.00;-#,##0.00") [modifying this to suit your
preferred format]

Signature

David Biddulph

> How do you merge Excel Data into a Word Document and keep the number
> format.
> E.G. 150,000.00. When I merge it merges as 150000

Reply to this Message

Dave Peterson - 21 Sep 2007 12:19 GMT

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

about half way down the page.

> How do you merge Excel Data into a Word Document and keep the number format.
> E.G. 150,000.00. When I merge it merges as 150000

Signature

Dave Peterson

Reply to this Message