Decimal numbers changing when importing from excel

[pintobean87]

I got an Excel sheet with different decimal numbers, but some change when they're brought over.

For example: 4.10 will become 4.1, and when looking in power query its 4.0999999999999. Or something like that.

It's doing that for quite a few of them. How do I fix this because I think it's messing up my sort order column I'm trying to create.

[amitchandak]

@pintobean87 , Increase the number of decimal places in column tools