The exported CSV file opens in Excel. Due to the default settings in Excel, zip codes that begin with a 0 may appear as four digit zip codes in your exported file. This could affect records from the following states: 

  1. Connecticut
  2. Massachusetts
  3. Maine
  4. New Hampshire
  5. New Jersey
  6. Rhode Island
  7. Vermont

To revert these zip codes back to their full 5 digits, open your export in Excel and highlight all zip codes from within the Zip column.

Click Format > Cells to open the dialogue box. 

Choose Special > Zip Code, and click Ok.

Your zip codes should now show as full 5 or 9 digits with any 0s in front that are applicable.

Still need help? Reach out to us using the on-screen help message icon or by emailing us at support@cannabiz.media.

Did this answer your question?