When we export data like zip codes, 0s get removed before I can edit excel column type.

Hi,

I need to be able to keep leading zeroes in a csv export (they are being removed from the export). Any quick way to format an export to do this?

Hi Blaine,

Thanks for reaching out to Jotform Support. Unfortunately, this can't be fixed in your Jotform tables as this is a settings issue with your Excel app. To fix this, I found an article that can help you keep the zeros of the Zip code. Kindly check it here.

Give it a try and let us know how it goes.

Thanks for the quick response. Unfortunately, you are incorrect. When exporting to a pdf, the leading zero is also removed.

Hi Blaine,

I answered your other question on a new thread. You can go ahead and check that out here.