This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have data in excel and all column's data type is string . let me explain below
if you see in screenshot zip column are also string i want to make column to specific datatype base on data in coulmn.
is there any logic which i could use to detect and change data type from string to date, number etc
This discussion from last year addresses this question:
Are you looking to choose the column you want to change the data type for or have determined for you?
Have you tried using the Auto Field Tool?
you can use auto field to change the data types as per data in fields.