Date format in exported excel spreadsheet is incorrect
Legacy KB ID: 2125
Question
Why is the date format in my exported excel spreadsheet incorrect?
Answer
This can be the result of using 'illegal' characters which are characters the program does not recognize correctly.
Most likely you have used a '-' symbol to separate the day, month and year i.e.: 07/01/1975, please change all the given '-' characters to the '/' symbol and it would also help you to change the date preference to 4 digits only.
Now try exporting again to Excel.
Need more help -
