Forum Discussion
"Date and time" format issue after splitting a csv file into different columns
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.
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.
- Thanks a lot for your reply it worked for me 🙂
It worked while changing the format using the "Parameters" application, and not in the control panel.
If someone needs it, useful information can be found here in order to change the date format with the correct application: https://access-excel.tips/how-to-change-default-excel-date-format/
