Zip code's leading 0s are being truncated

  • Profile Image
    Shebu Mathew
    Asked 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 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
    Shebu Mathew
    Answered on June 13, 2013 at 11:17 AM

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

  • Profile Image
    Answered 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 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:

    The field is called: "Mobilszám"

  • Profile Image
    Answered on November 02, 2014 at 12:39 PM

    Hi deakintezet,

    I have moved your inquiry to a new thread:

    Your inquiry will be address there.

    Thank you.