- anniepriceAsked on October 12, 2015 at 06:31 AM
Hi there, we have DOB in many of our forms that is entered by the user as dd/mm/yy but when you look at the form submission the month is in words and when we export date to excel, its the same. We have tried to change the format of the column but cant.
Please could someone help ?
- BenAnswered on October 12, 2015 at 10:57 AM
Unfortunately the month can not be changed on your form, it can only be shown as a string (words) instead of the the number. However you can change the column format in your Excel file to show a different time even if it is exported as the name of the month.
While I am not using Excel, the steps are very similar, but I will show you the steps to do in Google Spreadsheet.
You should click on the header of the column so that all cells in that column are selected (Birth Date column). Once you do, you should click on Format then Number and select the one that you wish to have.
You can see a quick screen cap of the same:
As you can see I have downloaded the date details from your form to show you with the same data, and it turns them into the expected format.
Now in MS Excel, you have a bit more steps, but I was able to find a nice guide that you can follow to achieve the same: https://support.office.com/en-us/article/Format-a-date-the-way-you-want-8e10019e-d5d8-47a1-ba95-db95123d273e
Do of course let us know if you have any additional questions and we would be happy to assist with the same :)