I have a downloaded CSV file where the dates show like below when opened in my Excel 2010:
a.s.o... I've tried changing dates to UK, US, Swedish (I'm in Sweden, using Excel in English) and within the different languages changing the formats (d/m/y, dd/mm/yy, dd/mm/yyyy, etc). Nothing works. The administrator (of the application from which I downloaded the CSV) sees the correct dates when opening the same file. My colleague here in Sweden, sees the same as I do.
Starting to drive me up the wall, any input would be appreciated! Thanks!