0
I am using an excel spreadsheet as my data source in a Word document mail merge. I have formatted the amounts in excel as currency with 2 decimal places. When I complete the merge, the amounts have approximately 13 zeros added to the end. See example below. Not sure if this is a Word problem or Excel and could really use some helping fixing this. Below is the example of what I'm getting.
The current amount due on you water bill is
$94.120000000000005
. The amount PAST DUE is$40.280000000000001
. Please pay a MINIMUM of$40.280000000000001
by 4:30pm on Monday, October 6th, 2014, or the water supply will be turned off.
How can I get Word to stop adding the extra zeros?
The OP stated it is formatted correctly in Excel, but not in Word after the merge. – CharlieRB – 2014-09-16T13:48:59.860
I don't agree with down-voting this just because it's not a solution @CharlieRB favours. I've used Leeroy's solution myself, and while clunky, it's no more clunky than adding a bunch of characters to each field in Word. – Kit Johnson – 2015-12-09T08:58:32.263