Format Zip Codes that Start with a Zero for Importing Contacts

If you are preparing a spreadsheet to import contacts into Command, there is a consideration to be aware of if you need to enter a Postal Code that begins with zero. You must format the cells to display as text fields, otherwise products like Excel, Numbers and Google Sheets will take out the first zero:

Excel

Numbers

If you are using Numbers, click here to learn how to do this, make sure to choose the text category when formatting the cell.

Google Sheets

1. Highlight the cells you need to use for Zip Codes, then click on the "Format" option to open that menu.

2. Highlight or click on the "Number" option, then select "Plain text."

3. Now, you can enter in zip codes that start with zero, without worrying about the formatting breaking your import.