All looks well in the spreadsheet, but when I bring the data into a mail merge in Word, my numbers are displaying with 17-19 decimal places. I'm having trouble figuring out how to properly round this so it only displays to 2 decimal places when brought into a mail merge.
With the cell formatted to General - the result displays as .6
When I copy and paste special values into a new cell the value is .6
When I pull the field into a mail merge the value is 0.59999999999999998
=ROUND((VLOOKUP(V2,Sheet3!$A$7:$B$11,2,0)+VLOOKUP(W2,Sheet3!$A$7:$B$11,2,0)+VLOOKUP(X2,Sheet3!$A$7:$B$11,2,0)+VLOOKUP(Y2,Sheet3!$A$7:$B$11,2,0)+VLOOKUP(Z2,Sheet3!$A$7:$B$11,2,0))/5,2)
I've tried a few different variations moving the () around with no luck.
Any help is appreciated.
Thanks
Bookmarks