Forum Discussion
Error Convert Text to Number
@ehsanbh , check for space.
Create a new column with Text.Trim and convert it to decimal and see if it works. It means it's a problem to have white space.
if necessary, see how to handle the error in the power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs- @ehsanbh You are welcome. I'm glad it worked.
PS, you can mark more than one answer as a solution, since Amit and I responded around the same idea with similar suggestions - great minds think the same. 🙂
I read the solution but still cannot solve this problem. My number is like this 123,456 and when I change data type in power query, the whole columns show errors. What do I have to do? Thank you
Replace the "," with nothing and redefine the variable type
Thank you so much. It works now but just for one column, I have a problem that all of my numerical data always automatically has comma between number. Do you know any setting to get rid of this in the future?
