Avatar of OnsiteComputerDoctor
OnsiteComputerDoctor
 asked on

Odd results from Word List Merge from Excel Data

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.
Microsoft OfficeMicrosoft ExcelMicrosoft WordSQL

Avatar of undefined
Last Comment
OnsiteComputerDoctor

8/22/2022 - Mon
crystal (strive4peace) - Microsoft MVP, Access

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

ASKER CERTIFIED SOLUTION
Flyster

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
OnsiteComputerDoctor

ASKER
Does word recognize numeric versus text in a list merge?
OnsiteComputerDoctor

ASKER
Thank you!!!!
Your help has saved me hundreds of hours of internet surfing.
fblack61