Forum Discussion
Solved
"Date and time" format issue after splitting a csv file into different columns
Hello, I have a csv file that I can open with Excel. This file has data with a "date and time" format which is the same for every row. Then, when splitting the text from the csv file into differen...
The dates are in US format m/d/yy, but Excel has tried to interpret them as d/m/yy.
12/28/20 is not a valid date in d/m/yy format, so it has been left as text (tell-tale sign: it's left-aligned).
Others could be interpreted as d/m/yy, but day and month come out switched.
One workaround is to switch your system date format to m/d/yy temporarily before importing the data, then switching back to the original setting afterwards.
ErnestoCB In step 3 of 3, select Date MJA for the date column as it seems that the dates are in a month/day/year format.