-
elsacAsked 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
-
David JotForm SupportReplied 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.