Forum Discussion
Power Query - Text to Number Error
Hello! I am currently busy with loading a new Query in Power Query. However, I cannot seem to transform a text column to number >> >> I have tried new column trim a...
Hi Mischa ,
It works fine on my device.
You got this error because your column contents are not only numbers they are alphanumeric so they couldnt totally get converted. Please convert the error column into text and check if there are any columns that are not numbers.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you want to keep your column data intact, when uploading your files select the "Do not detect data types" option.