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...
Mischa , I think there is still some character, click on the error and check what error you get, and try to address that. Also change to decimal then currency first
Hi amitchandak !
I have tried TRIM then converting to dec number, whole number or currency. All of which render no results.
See error message
I have also tried Clean and then converting to the various number formats
Still no luck 😞