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.
+12To preserve any leading zeros in values, you can use a Single line text field, rather than a Number field.
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.
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
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.
Not to mention wanting to retain Zip Plus 4 rather than subtracting Plus 4 from Zip…
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?
+4Hi 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?
+35Hi 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?
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.