- DannyTAsked on July 14, 2011 at 03:29 PM
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.
- JotForm SupportNeilVicenteAnswered on July 14, 2011 at 04:09 PM
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!