Zip Code starting with "0"

Heath_Stricklan · ‎Feb 23, 2017

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.

Matt_Bush · ‎Feb 23, 2017

To preserve any leading zeros in values, you can use a Single line text field, rather than a Number field.

Gordon_Maclean · ‎Jan 22, 2018

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.

Ed_Brown1 · ‎Sep 10, 2018

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

W_Vann_Hall · ‎Sep 10, 2018

Not to mention wanting to retain Zip Plus 4 rather than subtracting Plus 4 from Zip…

Raffaella_Pace · ‎Dec 11, 2019

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?

Jemima_Garthwai · ‎Oct 05, 2020

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?

ScottWorld · ‎Oct 05, 2020

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.