When I download the spreadsheet into my Excel files, the format of the submission time stamp changes to DD/MM/YYYY 00:00, whereas the time stamp for a date entered within the form is listed as MM/DD/YYYY.
Is there a setting somewhere (FormsCentral or Excel) that lets me adjust the formatting of both dates so they are identical?
To change the date format for the time stamp go to the View Responses tab, select the Time Submitted fields (not the whole column), click on Table button in the toolbar and select the date format you wish to use from the date format drop down. The date format set up in the Responses table is the format that will be exported.
Thanks! That worked.
Is there a way to set a default time format that will then be applied automatically to any new forms?
This is not something we currently support but you can add or vote on feature ideas:
If you need to add a new idea click "Create an idea" under "Actions" in the top right.