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

    Phone Number Zero to the Left is Removed when Submissions Exported to Excel

    Asked by s.whitelaw@silverstrand.com.au on May 06, 2014 at 08:04 PM
    excel phone number
  • Profile Image

    Answered by s.whitelaw@silverstrand.com.au on May 06, 2014 at 08:05 PM

    Without having to change it in excel ie: adding an ' in front of the 0

  • Profile Image

    Answered by Cesar on May 06, 2014 at 11:35 PM

    I have tested your form and a simple test form. This definitely does happen on the text field tool. I have tested the Phone Tool field and that tool appears to allow the zero to go first:

    https://shots.jotform.com/cesar/screens/zerofirsttest.png

    Do note this tool does contain an Area Code portion.

    https://shots.jotform.com/cesar/screens/phonenumbertool.png

    In any case, I will raise your initial concern to the Dev Team so that they are able to review the possibility of making the text field to be used without removing the initial zero when exported to Excel. If they have any updates on this, they will let us know through this thread.

    Do let us know if you need further assistance. Thank you.

  • Profile Image
    JotForm Support

    Answered by alp_deniz on May 20, 2014 at 02:36 AM

    This issue has been recently fixed. Thank you very much for reporting. 

    Kind regards