Mail Merge shows too many decimal places - TechRepublic
General discussion
October 22, 2004 at 09:01 AM
jbanwarth

Mail Merge shows too many decimal places

by jbanwarth . Updated 14 years, 2 months ago

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!

This discussion is locked

All Comments