How to fix Date Format when being downloaded as CSV

I have set up the date field on my form with the format DD-MM-YYYY, but when I download the submissions to csv, and then open it in Excel, the date field is displaying MM/DD/YYYY which means that some entries are being treated as text and others are displaying incorrectly. e.g. a date of birth which is 4th September 1976, was entered in the form in the three field boxes as 04 09 1976, but it is showing as 9/04/1976 and another date 21st November 1977 (entered as 21 11 1977) is showing as 11/21/1977. Changing the date format in Excel (for example to d-mmm-yyyy) does not fix it. The first date converts to 9-Apr-1976 (which is incorrect) and the second date doesn't convert at all. How do I fix this problem?

Hi Bruce,

Thanks for reaching out to Jotform Support. I’m sorry that this is happening. I see that you'd like to change the date format to DD-MM-YYYY, and this can be easily done by adjusting the settings in your Jotform Tables. Let me show you how:

1. In Form Tables, click the Column date drop down.
2. Scroll down and click Date Format.
3. Select your desired Format.

Take a look at the screenshot below to see my results:

Keep us updated and let us know if you need any more help.

Hi Bruce,

As for your other questions, I've moved that to a new thread. You can check that out here.

Let us know if you have any other questions.