Odd results from Word List Merge from Excel Data

OnsiteComputerDoctor
OnsiteComputerDoctor used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
Excel does not have data types, in regular ranges -- so what you are seeing is double precision numbers, which are not exact.  In Excel, you can try wrapping equations with ROUND -- it that does not do it, let us know ... more ideas ...
=Round(expression, number-of-digits)

Open in new window

Select Alt+F9. This should reveal your field codes. It will look something like this:

{MERGEFIELD "Number_Data"}

Change it to {MERGEFIELD "Number_Data" \ ##.##}

Select Alt+F9 again to hide the code again

Flyster
Does word recognize numeric versus text in a list merge?
Thank you!!!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial