JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
When using import app to manual add submissions to my form, it displays a birth-date as a decimal.Asked by atytus on October 13, 2016 at 06:02 PM
I would like to import submissions to my form manually. On my form I have my clients enter their date of birth. When I try to import an excel file with a birthdate into my form using the import app, it converts the date of birth to a decimal like 1.6666. How do I avoid this?
Can you please try changing the format of the cells to text so they will not be changed by excel? Please follow the steps below:
1. Select all the cells
2. Right click then select Format Cells
3. On the Number tab, select the Text category and then click OK.
4. Save the file then try importing it again using the import app. The date of birth on the submission should now look like the one below.
You can also check out this guide for more info about the import app: Import App: Easily import your Excel or CSV data into JotForm
Please let us know if you need further assistance.