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.
Leading zero in date value is being removed in submission excel.Asked by ITU_contacts on August 25, 2014 at 08:18 PM
I'm using the date of birth fields, and I am exporting the data of the form into a spreadsheet.
I have been requested that the output be mm/dd/yyyy, for example 01/01/1980, but if the month and days are only one number, the output is 1/1/1980
Is there a way to get the double digits also where the input is january through september, and for numbers 1 to 9?
I did check this issue by creating a simple demo form and I am unable to replicate the issue you are having. When I exported the form submissions in excel, it did not remove the leading zeros from the date value. Please check the screenshot below:
I would suggest you to test your form again and get back to us if the issue persists.
I'm afraid I made a mistake in explaining how the form works: it is connected to a google spreadsheet, therefor I don't manually export the data, it is funneled into it automatically.
I'm attaching a screenshot of part of the form, with test data.
Column L is the birthdate picker. Column M is the insert Date picker. In both cases, the output is month and day without the zero, if only one digit.
Do you know if there is something I can do about this?
Thank you for your help!
I believe this formatting is done in the Google spreadsheet. I believe you can change the formatting in the sheet itself:
Let us know if this does not work for you and we will be happy to see what else we can find.
Thank you for using JotForm!
yes, I ended up doing that, unfortunately every time new data gets input, it still has the format without the leading zero.
I was hoping there was a more automatic way to do it, instead of "formatting" every time the column.
I don't know why it doesn't keep the format I gave for new data too, Excel does that.
Thank you anyway. :-)
It does look like it is an issue with the way the spreadsheet does the initial formatting of the data sent to it by our forms. I did a few tests and had the same results as you. Sorry we couldn't be more help with this. Please let us know if there is anything else we can help you with.