id="info"

Question

Locked

MERGE FROM EXCEL INTO A WORD DOCUMENT-FORMATTING PROBLEM

By suzanne_juszcyk ·
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

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Display Excel Number Formats in a Word Mail Merge

by AtCollege In reply to MERGE FROM EXCEL INTO A W ...

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

Back to Software Forum
2 total posts (Page 1 of 1)  

Software Forums