Question Locked
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 suzanne_juszcyk Accepted solution
Clarifications
by atcollege Accepted solution
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.
Trending Software posts
Sort by Trending
1 helpful
1 reply
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies
0 helpful
20 replies
Discussion
Is There any Reverse Video Search Tool
0 helpful
8 replies