Forum Discussion
Error Convert Text to Number, one column contains text and number
Hi,
I have a column cotains text and number. It automatically convert it to Number. I changed the datatype to Text in power quert editor, but still got error: couldn't convert to Number. Do you know how I can fix this? Thanks so much.
If you look in the lists of steps on the right hand side I'm guessing you now have two "Changed Type" steps.
You need to go back and click on the first one and change the type of the column at that point to text. It will ask if you want to overright the step. Click yes.
3 Replies
- bcdobbs
Community Champion
If you look in the lists of steps on the right hand side I'm guessing you now have two "Changed Type" steps.
You need to go back and click on the first one and change the type of the column at that point to text. It will ask if you want to overright the step. Click yes.
Thanks so much!! It fixed!
