
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 23, 2017 08:22 AM
How do you insert a zip code in a record when the zip code begins with “0”? In excel, I would place an “’” ahead of the 0 and it would remain. Thanks for the help.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 23, 2017 11:40 AM
To preserve any leading zeros in values, you can use a Single line text field, rather than a Number field.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 22, 2018 12:35 PM
I know this is a long time since posting, but zip codes should be treated as a text rather than a number. Rule of thumb, if it does not make sense to do math on a number, make it a text. You wouldnt multiply zipcodes.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 10, 2018 01:13 PM
And six months after the last one… It would be very nice to be able to do a “between” filter for zip codes… ! ie. between 01925 and 02999

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 10, 2018 07:06 PM
Not to mention wanting to retain Zip Plus 4 rather than subtracting Plus 4 from Zip…

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 11, 2019 09:37 AM
Hi everybody, I did as suggested, but when I exported it as a csv file all the zip codes starting with 0
have been automatically shortened, and the 0 has been deleted (Example code 00100 become 100).
Any suggestion?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 05, 2020 11:02 AM
Hi all. I have this same issue. It’s not zip codes, but an important number that must be exported to Excel as ‘0001’.
- I have already formatted the field as Text in Airtable.
- I export the table to CSV, which if read in a text reader shows “0001”
- But once it opens in Excel or Numbers or G Sheets, the leading zeros disappear, and that when the file opens, that field shows ‘1’.
- This is not a matter of formatting in the Excel/Numbers file - the zeros have just disappeared.
Any suggestions?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 05, 2020 11:23 AM
In Google Sheets, one way to fix this problem before importing the CSV file is to turn off the option to “convert text to numbers” that shows up when you import a CSV file. See screenshot below.
