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

    Zip code's leading 0s are being truncated

    Asked by Shebu Mathew on June 13, 2013 at 07:09 AM

    Is there a way to keep the leading 0s of a zip code when integrating with google spreadsheet.

    For example: in jotform my zip code is entered as 08872. When the form is submitted which is integrated with google spreadsheet it shows up as 8872 versus 08872.  Is there a way that the 0 can be preserved?  

  • Profile Image

    Answered by dinesh-it on June 13, 2013 at 08:14 AM

    Hi, change the data type of the column to Plain Text in the Google spreadsheet.

    1. Open your spreadsheet and select the column that has the post codes.

    2. Select Format from the menu bar, then select number, then select plain text.

    Plain Text Format in google spreadsheet


    Hope this will solve your problem.

    Thank you.

  • Profile Image

    Answered by Shebu Mathew on June 13, 2013 at 11:17 AM

    I tried that and it still not adding the leading 0.

  • Profile Image
    JotForm Support

    Answered by Welvin on June 13, 2013 at 12:35 PM

    Hi Shebu,

    That should only work for new upcoming submissions. Have you tried to send test entry to see the changes? If not, please try that and let us know the results.


  • Profile Image

    Answered by deakintezet on November 02, 2014 at 11:25 AM

    I tried the same as you write it, no results... I got the numbers without zero... this is the form: http://form.jotformeu.com/form/40973466690364?

    The field is called: "Mobilszám"

  • Profile Image

    Answered by Shadae on November 02, 2014 at 12:39 PM

    Hi deakintezet,

    I have moved your inquiry to a new thread: http://www.jotform.com/answers/453035

    Your inquiry will be address there.

    Thank you.