Forum Discussion
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 have 3901-4293AC
I have changed the column format to text to avoid errors but I keep getting "DataFormat.Error: We couldn't convert to Number."
Can someone please help?
Thanks!
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
9 Replies
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
I have the same issue but I remove some steps in applied steps frame, the value return blank instead of text value.
Please instruct me how to fix it
Thanks
Linh
In the applied steps pane there should be a step that sets the data types. I would find the column causing the error and change the data type to "type any". You can enter this in the Formula bar at the top of the page.
Thank you for posting this. Seems like little advice but prevents you from chasing your tail.
I had a similar issue today. WOuld like to pivot a set of data ,
e.g. Area A/B/C in column 1, Sales X/Y/Z in column 2,
into Column 1 (Area A /Sales X), Column 2 (Area b/Sales Y), COlumn 3 (Area C/Sales Z).
After reading this trail, I realized pivoting can only be made, after converting column SALES XYZ from numbers into text format. But why is that? Isn't the purpose of the pivot to add up numbers and that could only be made via number format?
