Power Query creates long decimal tails

[cr731]

I'm using Power Query to pull data out of an Access database. All numbers in Access are rounded to two decimals.

When I query this data in Power Query, I get long decimal tails... 6.53 becomes 6.530000002098.

I'm not performing any calculations on the numbers - I'm just unpivoting in Power Query to put columns of months into a single column.

Is anyone familiar with this happening?

 

[Matt Allington]

Are your numbers in Access formatted or rounded? They are not the same thing. Just round them in Power Query.