I need some help here.
I’m working on a mail merge in Word 2007. I have a database in Excel containing various amounts—basically numeric data with two decimal places. The issue is that when the data pulls into Word, it either strips the decimals entirely or, if the value isn't zero, it brings over way too many decimal places. How can I fix this formatting?
I’m working on a mail merge in Word 2007. I have a database in Excel containing various amounts—basically numeric data with two decimal places. The issue is that when the data pulls into Word, it either strips the decimals entirely or, if the value isn't zero, it brings over way too many decimal places. How can I fix this formatting?