Phone Number Standardization

Smart CRM & Sales Hub CRM
,
1

Hello,

when we imported our user data, the phone numbers were in a variety of formats (we are in the US):

800-123-4567

(800)-123-4567

8001234567

etc

is there any easy way to standardize this - either with AI credits or a tool? We are realizing that not having consistent formatting is throwing off some of our reporting and voip integrations. Or are we just retyping them ?

thanks.

2

Hello @TMwd, you could create the workflow using the instruction in this article link https://knowledge.hubspot.com/workflows/format-phone-numbers-using-workflows

You can also select the default code to add to these numbers when setting up the workflow actions. Hope this helps.