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

    Leading Zeroes Removed in Postal Code Values in Excel Reports

    Asked by DannyT on July 14, 2011 at 03:29 PM

    Hi.

    You have a gread Postleizahl-Element in your Address Element. But there is a big Problem when you Download the Data as XLS. When the Postleitzahl starts with a 0, this  is missing.

     

    01111 -> 1111

    02222 -> 2222

     

    Maybe you can fix this? It make big problems in serial letters.

     

    Thanks a lot.

    Danny

  • Profile Image
    JotForm Support

    Answered by NeilVicente on July 14, 2011 at 04:09 PM

    Hi Danny,

    This problem lies not within Jotform's system but rather within Excel itself. Excel automatically strips leading zeroes in cells that are formatted as numbers. In order to remedy this, you would have to change the format of the cells that contain the zip codes.

    I searched the web and found this excellent tutorial on how to keep the zeroes in your postal code values. Please read on and follow the instructions carefully.

    Hopefully, this solution works for you. Let us know if you're experiencing any difficulties with it. Thanks and have a great day!


    Regards,
    Neil