Forum Discussion
Excel interprets dates inconsistently ddmmyy vs mmddyy
When importing a text file with dates in the dd/mm/yyyy format excel incorrectly interprets them as mm/dd/yyyy wherever it can when copied to a new spreadsheet. Eg it interprets 13/05/2019 as 13 May ...
What is your default date format for OS? And if you import by wizard do you apply Date format on third step?
Hi Sergei. You mentioned the Wizard so I have used that method and problem solved. Obviously the Wizard allows you to correctly specify the format so no problemws.
I don't know why I didn't use that in the first place