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

    Why do some of my submissions' numerical amounts download in a different format when i download the excel file

    Asked by LADSON on April 09, 2012 at 10:52 AM
  • Profile Image

    Answered by gori-mathew on April 09, 2012 at 12:50 PM

    Hi,

    We apologise for this issue you are having. Can you share with us some more information especially on what you mean by 'different format'. You can also gives the form's URL for this submission to check and see if we can re-produce the same issue.

    Thanks for contacting us .

  • Profile Image

    Answered by LADSON on April 09, 2012 at 01:05 PM

    Thanks.

    On my form my employees select a date from the date picker (calander) this is then placed into the data on the downloadable spreadsheet along with the other answers in the submission including the amount of hours they have worked (this is a simple quantity in numeric format). I then download the excel spreadsheet and organise the data as required and when i do this some of the values of the "hour" dont show up and they are even rearranged differently on the spreadsheet. Also the dates are no longer dates and have to be reformatted as dates.http://jotform.ca/form/20635001123232

  • Profile Image

    Answered by fxr on April 09, 2012 at 03:38 PM

    You are just going to have to format the columns after you have downloaded the Excel doc, there is no way for the program that generates the Excel doc to know if the that particular cell is supposed to be a number, a string or a date. 

    It takes 10 seconds to format the columns after you have downloaded the Excel doc of your submissions. Do it at the start before you begin organising the data.