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

  • Profile Image
    s.whitelaw@silverstrand.com.au
    Asked on May 06, 2014 at 08:04 PM
  • Profile Image
    s.whitelaw@silverstrand.com.au
    Answered 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
    Cesar
    Answered 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
    alp_deniz
    Answered on May 20, 2014 at 02:36 AM

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

    Kind regards