We help IT Professionals succeed at work.
Get Started

Odd results from Word List Merge from Excel Data

67 Views
Last Modified: 2015-12-03
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.
Comment
Watch Question
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE