Hi, there seems to be a bug in Excel that during some special circumstances changes the format of dates when pasted into Excel from different software. What happens is that dates where the day is <=12, for instance, 04.05.2020 will be turned around to 05.04.2020. That does for course create some problems.
All dates which are correct has this formatting dd/mm/yyyy 00:00:00, and all have a date higher than 12. All dates which are turned around for some reason have this formatting dd/mm/yyyy 00:00, and are <=12. So all are under 12, and misses the seconds in the time formatting.
As I understand this bug was only there in the 2013 version, but I have the same issue in Office Excel 365 so I guess it is still there.
Does anybody has a suggestion for a simple workaround?
All dates which are correct has this formatting dd/mm/yyyy 00:00:00, and all have a date higher than 12. All dates which are turned around for some reason have this formatting dd/mm/yyyy 00:00, and are <=12. So all are under 12, and misses the seconds in the time formatting.
As I understand this bug was only there in the 2013 version, but I have the same issue in Office Excel 365 so I guess it is still there.
Does anybody has a suggestion for a simple workaround?
Last edited: