https://legacy.forums.gravityhelp.com/topic/zip-code-zeroes-stripped-on-export Gravity Support Forums Topic: Zip Code zeroes stripped on export en-US Tue, 21 Apr 2026 17:37:13 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/zip-code-zeroes-stripped-on-export#post-346224 Wed, 26 Jun 2013 15:03:23 +0000 Rob Harrell 346224@https://legacy.forums.gravityhelp.com/ <p>It's showing correct for me: <a href="https://www.evernote.com/shard/s212/sh/f458f390-0c6b-44ad-8cc6-0ac3b51d1141/78c6de88b5375d3511bbe9a61f1c678b" rel="nofollow">screenshot</a> </p> https://legacy.forums.gravityhelp.com/topic/zip-code-zeroes-stripped-on-export#post-346223 Wed, 26 Jun 2013 15:00:43 +0000 endgamepr 346223@https://legacy.forums.gravityhelp.com/ <p>I exported a fresh CSV and opened it this time in Google Docs instead of Excel, and it had the same problem. Here's a copy of the file (without addresses and names) if that helps: <a href="https://dl.dropboxusercontent.com/u/11138065/pillow-engagement-2013-06-26%20%281%29.csv" rel="nofollow">https://dl.dropboxusercontent.com/u/11138065/pillow-engagement-2013-06-26%20%281%29.csv</a> </p> https://legacy.forums.gravityhelp.com/topic/zip-code-zeroes-stripped-on-export#post-346187 Wed, 26 Jun 2013 14:23:25 +0000 Rob Harrell 346187@https://legacy.forums.gravityhelp.com/ <p>I can not replicate this on my dev site. If you are using excel, the csv should have the leading zero, i think you may need to set your column up correctly. It's most likely how you are trying to view the data that is the issue.</p> <p>Excel does have this lame thing where it sets the data type for the column based on the first row of data, which screws numbers up all the time. </p> https://legacy.forums.gravityhelp.com/topic/zip-code-zeroes-stripped-on-export#post-346105 Wed, 26 Jun 2013 13:34:02 +0000 endgamepr 346105@https://legacy.forums.gravityhelp.com/ <p>We created a form to capture addresses for a giveaway we're doing. However, when I exported the entries so that they could go to the shipping house, we found that some of the zip codes were truncated to four digits. Upon investigation, we found that the ones that were truncated were ones that started with a zero. Is there any way to keep this from happening? </p>