SAP data to Excel sheet. Dates are not in Dates format

Question

I have extracted data from SAP and now I want to uses this data on excel sheet and perform certain action. However, data is time series data and dates are not in dates format.

I see 01/9/2009 in excel sheet but when I double click that cell the date appears as '01/9/2009. I even tried pasting as values but in that case it reads it as day/Month/Year instead of Month/Day/year.

Please help me out on this. I have lot of data so cannot do manually.

Answer 1

Assuming these dates are in a column, select it, Text to Columns, Tab delimited and at Step 3 of 3 select Date: and MDY.