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 recognise 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

How did we do?


Powered by HelpDocs