Forum Discussion
Solved
Dataformat.Error: We couldn't convert to Number
Hi all, I have a column that have a mixture of numbers and text. Some cells consist of only numbers while others have a mixture. For example, I have a cell that have 4230290 and another that hav...
It could be that there's an earlier step in your query that's trying to convert that column to a number, try looking to see whether there is and removing it
You are looking at the "Errors in Billing condition" table when you should be looking at the "Billing condition" table. In there, a step should exist for Changed Type. Find the problem column and change it as shown below:
If the formula bar below is not showing you need to select Formula Bar, which can be found under the View tab.
