- elsacAsked on September 18, 2014 at 11:05 AM
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,
- JotForm SupportdavidAnswered on September 18, 2014 at 12:44 PM
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:
If this is not what you were looking for, please let us know and we will be happy to assist you further.