Forum Discussion
How can I clean this date data in Excel?
The dates are in mm/dd/yy format while your format is yyyy-mm-dd. If Excel can interpret an mm/dd/yy value as an yyyy-mm-dd value, it will convert it to a date, otherwise it will leave it as text.
You can use Power Query (Data tab of the ribbon > From Text/CSV in the Get & Transform Data group) to convert all the values correctly.
The dates are in mm/dd/yy format while your format is yyyy-mm-dd. If Excel can interpret an mm/dd/yy value as an yyyy-mm-dd value, it will convert it to a date, otherwise it will leave it as text.
You can use Power Query (Data tab of the ribbon > From Text/CSV in the Get & Transform Data group) to convert all the values correctly.
Awesome that works! Also figured out another way using Text to Columns in Data > Data Tools to change the format from yyyy-mm-dd to what I needed. Thank you!
