Forum Discussion

prakash11440278's avatar
prakash11440278
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

[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? 

 

1 Reply

  • VijayP's avatar
    VijayP
    Icon for Community Champion rankCommunity Champion

    prakash11440278 

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