Submission date format in excel report

Hi!

Submission date is on yyyy-mm-dd format, what is the best format for us. 

In the last days, the "Answers" are in the right format, but when we download the excel they convert to mm-dd-yyyy. Since we copy/past all the entries to the same excel, we now have different formats there that are more difficult to align correctly.

Is there a way to download in the yyyy-mm-dd format?

Thank you very much,

EC

Hi,

I believe this is a setting that can be changed in excel as the program itself interprets the data and displays it this way.  Here is a guide on how to change the format:

http://office.microsoft.com/en-us/excel-help/format-a-date-the-way-you-want-HA102809474.aspx

If this is not what you were looking for, please let us know and we will be happy to assist you further.