Submission date format in excel report

  • Profile Image
    elsac
    Asked on September 18, 2014 at 11:05 AM

    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

  • Profile Image
    david
    Answered on September 18, 2014 at 12:44 PM

    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.