[dateformat.error] we couldn't convert to number

[prakash11440278]

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? 

[VijayP · Accepted solution]

@prakash11440278 

In power query editor change the column type to Text and then it never throws error!