Rounding issues

[Mischief63]

PROBLEM: Query from folder of excel spreadsheets. The column shows the correct number of cents (e.g. .47) in the original spreadsheet. I cannot get it to stop rounding up in get and transform though I've tried, splitting and remerging, changing it to text and just about every other command I can think of.

I finally got it to show the entire list of digits after I trimmed it (of course that changes it to text):

71750000
-2575.1999999999998
256691730.47

But then I try and change it to a number format and No matter what I do it rounds the .47 up to .50

Any ideas?

 

[Matt Allington]

Can you post the power query code