I had this problem also and found a solution that makes it work the correct
way.

From Word, Click on the Microsoft Office Button, click on Work Option (lower
right hand corner), click advanced, move down to the General area and check
Confirm File Format Conversion on Open. I did this and now it works
perfectly.

"Perkgolf" wrote:

Thanks. I'll try that.

Bruce

"Dave Peterson" wrote:

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/as...164951033.aspx

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

http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.

Perkgolf wrote:

Hi,
I'm losing my number formatting when I merge my Excel sheet into my Word
doc? Any ideas?

Thanks
Bruce

--

Dave Peterson