Leaderboard

Thank you for clearing that up Sean, you rock. I'll add an option to change the date format sitewide.

From a quick check on my end, the issue is that Excel expects dates to be formatted as DD/MM/YYYY (how we write dates in Ireland), but the CSV file has them written as MM/DD/YYYY, the way the USA writes dates. When Excel reads in the CSV file, it read the lines like 06/01/2019 as the 6th January 2019, 8/02/2019 as the 8th February 2019 and so on until it reaches a 13 or higher digit in the middle, such as 05/13/2019. As there is no 13th month, it will treat this as a text field and in turn left-align them. This continues until it reaches a line that contains a digit of 12 or less in the middle of the date, which again it reads as a valid month. Microsoft recently changed the CSV importing process in Office 365 (which I use), so these steps below may not correspond with your Excel version. Go into the Data column (1), click 'Get Data' (2), 'From File' (3) and then 'From Text/CSV' (4): Choose the downloaded CSV file, then click 'Transform Data': Right-click the Column1 heading (1), then go into 'Change Type' (2) => 'Use Locale...' (3): Choose 'Date/Time' for the Date Type field (1), then 'English (United States)' for the Locale field (2), then click 'OK': Finally click the "Close & Load" icon (4 in above screenshot) and it should import and present them in your locale date format, e.g. dd/mm/yyyy for my region: ?