I have researched this some more and found a sort of fix - store the dates as mm/dd/yyyy in your CSV file and they get converted (correctly) to dd/mm/yyyy.
Admittedly it's a bit of a cheat, but it works.
All the best
Chris
Hi,
Further to SmallCraig's note, Excel makes a complete hash of dates where the "dd" portion of the date is > 12.
As it can't validate it as a valid month, it converts the whole cell to text. You then end up with a combination of reversed dates and text [sad]
One point, the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.