Convert us to european date excel
Hi, I have an Excel worksheet of data with dates all in European style (dd/mm/yyyy). I copy and paste the data in to Access. I would like the dates to convert to US date style in the Access table. I am US-based and getting a report that gives me dates in European text format. All the data/dates in a column in in the Europe format and stored as text. The format is dd.mm.yyyy. If I copy it and paste it into notepad it pastes as dd.mm.yyyy so it's not stored as date in excel. I know it's EU format because "12.05.2017" is May 12th, 2017.