What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Change Birth Date widget to show month as a number instead of text

    Asked by annieprice 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 ?

    Thanks

    Page URL:
    https://form.jotform.com/40203421353943

    excel format date birth date
  • Profile Image

    Answered by Ben 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 :)