Forum Discussion
pintobean87
3 years agoFrequent Visitor
Decimal numbers changing when importing from excel
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.
1 Reply
- amitchandakSuper User