Leading Zeroes Removed in Postal Code Values in Excel Reports

  • Profile Image
    DannyT
    Asked 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
    NeilVicente
    Answered 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