Forum Discussion
Power Query - Text to Number Error
hi PC2790,
Still no success
unsure why it isn't working, I have tried everything I can think of
you can find the csv in here
https://files.onlineintelligence.co.za/f/55e6066262bf4982a15d/?dl=1
Product-Lookup
Could this perhaps be a settings issue?
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.
