Discussions

Mail Merge shows too many decimal places

Tags:
+
0 Votes
Locked

Mail Merge shows too many decimal places

jbanwarth
In Word 2003, I am experiencing a problems using mail merge with an Excel data source. The issue comes up when you have a number in Excel; i.e., 1.333. The number is formatted in Excel to display only 3 decimal places, however when you use mail merge and bring that data source into Word, the number will display an infinte number of decimal places; i.e., 1.3333333333333333... I've tried using the same Excel data source in Word 2000 and I don't have this problem so it is definitely a bug in 2003. Has anyone else experienced this issue or come up with a solution for it? (I realize this is regarding Office 2003 and I choose Office 2000, but there wasn't an Office 2003 to pick from. I'm hoping someone out there is using this version and can help!)
Thanks!