Print Letters with Mail Merge

[Chevrier]

This is my first time merging data from an Excel worksheet into a Word document. (Microsoft Office Word 2007/Microsoft Office Excel 2007) Everything will import correctly except the dollar amount. Ex: $3,687.12 will import as $3,687.12999999999999. Anyone know what I am doing wrong?

 

[jberwald]

Are the dollar amounts formated as currency with only 2 decimal points?

 

[Chevrier]

Yes

 

[jberwald]

Don't know why excel would do that.

Are all the numbers coming in with exactly 14 places after the decimal? Because I believe if you take off the last 12 numbers on ONE of your Word mailmerge letters - ALL the letters in the merge will delete 12 of those numbers.

 

[sudeep]

Or maybe you could try rounding off =round() in your excel, so there will be no long nos. for word to import.