I'm generating a data set in Excel using Power Query.
The query returns a Balance Due column.
When I use a list merge in Word querying data from the Excel sheet, I get the following anomaly in the results:
Excel Word
42.33 42.329999999999998
11.84 11.84
26.62 26.620000000000001
So, the way values are interpreted is incorrect.
If I increase the decimal display in excel, it has no affect.
As a test, I performed a Copy and Paste Special Values
and got the same results.
I will try to get sample files. However, the Power Query refers to my own folder structure and I also will have to delete personal information before sending it on.
Any thoughts are greatly appreciated.
Open in new window