Forum Discussion

Omega's avatar
Omega
Icon for Impactful Individual rankImpactful Individual
8 years ago
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...
Need Help
  • jthomson's avatar
    jthomson
    8 years ago

    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

linphan's avatar
linphan
Frequent Visitor
8 years ago

Thanks Jcarville. I can do it :smileyvery-happy:

jcarville's avatar
jcarville
Icon for Skilled Sharer rankSkilled Sharer
8 years ago

Excellent, please mark the solution so other people with the same issue can find a solution.