Forum Discussion
prakash11440278
Post Prodigy
3 years ago[dateformat.error] we couldn't convert to number
Hi All,
I have imported excel file where i am having full of integer values & few text values. The column when i import it is redirecting into error values in edit queries. How can we add those few text values in integer column?
In power query editor change the column type to Text and then it never throws error!
1 Reply
- VijayP
Community Champion
In power query editor change the column type to Text and then it never throws error!