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

  • Profile Image
    LADSON
    Asked on April 09, 2012 at 10:52 AM
  • Profile Image
    gori-mathew
    Answered 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
    LADSON
    Answered 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
    fxr
    Answered 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.