The postal code is a single-line text property and doesn't behave like a number property. Unfortunately that means that you cannot apply number filters.
If there aren't any postal codes that start with a 0, you could consider setting up a number property, copying the postal code from single-line text to number and then apply the number filters.
Lastly, you could also consider exporting the companies, filtering in an Excel file, then re-importing the filtered companies so you can identify by import. (When re-importing, make sure to map the record ID to avoid duplicates.)
Let me know if you have any follow-up questions!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
The postal code is a single-line text property and doesn't behave like a number property. Unfortunately that means that you cannot apply number filters.
If there aren't any postal codes that start with a 0, you could consider setting up a number property, copying the postal code from single-line text to number and then apply the number filters.
Lastly, you could also consider exporting the companies, filtering in an Excel file, then re-importing the filtered companies so you can identify by import. (When re-importing, make sure to map the record ID to avoid duplicates.)
Let me know if you have any follow-up questions!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
Thank you for the answer. I tried your first suggestion. We created a new number field on company. Then tried to automate with a workflow the copy process. The only problem is that the new field does not show up in available "field" to copy/paste in to. Seems like its only "standard" hubspot fields. Did i do anytging wrong when i created the new field?