I am trying to open a CSV file and the dates are in European format. This causes my macro to have all sorts of problems.
Code
starttime
30/06/2015
1/7/2015
2/7/2015
3/7/2015
4/7/2015
5/7/2015
6/7/2015
7/7/2015
8/7/2015
9/7/2015
10/7/2015
11/7/2015
12/7/2015
13/07/2015
14/07/2015
15/07/2015
16/07/2015
17/07/2015
18/07/2015
19/07/2015
20/07/2015
21/07/2015
22/07/2015
23/07/2015
Display More
Is there a way to open the file and have excel know that this is European format? Then allow me to convert from European to US. I could probably use some form of text conversion but the result of opening the file leaves a mix of dates and strings depending on whether the first number is between 1 and 12 or 13 to 31.