Question Locked

MERGE FROM EXCEL INTO A WORD DOCUMENT-FORMATTING PROBLEM

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm using an Excel spreadsheet for data for a Word main document. I'm having trouble with numbers; if they are automatically formatted with the dollar sign and two decimal places, i.e., $1,200.00, the dollar sign, period and zeros at the end do not merge into my Word document when I merge them, just the number (1200) comes in. The only way it will work if I manually type them in and have the cell formatted to text. Why is this happening? And is there anyway to get it work? thanks

2 replies

by atcollege

In Word 2003, go to Tools, Options...then click the General tab. Check Confirm conversion on Open.
In Excel, make sure the list is on the first sheet.
Then in Word, when you select the recipient list, choose the DDE type of connection.

If you are still having problems, you may also want to download the floating point calculation fix.
http://blogs.msdn.com/excel/archive/2007/10/09/calculation-issue-update-fix-available.aspx

This discussion is closed to new replies.