Yes please, we also need the same number formatting that hubspot uses in their forms.
pretty please? 
Would be great to have this on internal hubspot app functionality as well - not just forms.
Contacts/Company/etc
Maybe a property type of “phone number”
That is true, it should be applied to everything so numbers are fixed!
[doubble posted, ignore this]
+1
+1
Love this idea! This would be really beneficial, especially for CRM integrations.
Type A personalities, like me, would really appreciate this update soon. Uniformity with data display is a good thing.
HOW TO FORMAT PHONE NUMBERS WITH HUBSPOT & ZAPIER
After having the same problem for years, I finally found what I believe to be the best solution to this problem. It’s pretty easy to do, but there are quite a few steps to get it done.
-
Create an account at Zapier (basic accounts are free, pro accounts are cheap) if you don’t already have one https://zapier.com
-
Once you’re logged into Zapier, click on Make a Zap! at the top right corner of the page
-
Choose a trigger app by typing in Hubspot into the search field, and click on Hubspot from the results below the search box
- Choose what is going to trigger the Zap to run by selecting “New Contact”. This will cause this Zap to run every time a new contact is created
- Connect your Hubspot account to Zapier. If you are currently logged into Hubspot, this should be a really easy process and then click Save + Continue after your Hubspot account is connected to Zapier.
- The next step allows you to choose what contact you want to test this Zap on which will be pulled directly from the last 3 contacts that have been created in Hubspot. Click on the arrow to the right of Contact A, search the term “Phone Number” to filter out the phone number field, and make sure the phone number that shows is improperly formatted. If you don’t find a contact with a improperly formatted phone number, there will be nothing for this Zap to do.
If you are unable to find a contact that has an improperly formatted phone number, you can also keep clicking the “Get More Samples” button at the bottom of the page and it will pull more contacts in for you to choose. If after you pull in another 1 or 2 sets of cotacts, Zapier will stop pulling in existing contacts from Hubspot and instead ask you to create a new contact in Hubspot and it will pull that contact in. In that case, just simply create a new contact in Hubspot with an improperly formatted phone number and it will be pulled into Zapier pretty quickly.
Once you have selected the right contact, click on Continue.
- Now that you have pulled in a contact from Hubspot, you need to tell Zapier what to do with it. In this case, we want to run a tool that Zapier created recently called “Formatter”. To do that, click on “Add A Step” from the left hand sidebar.
- A new panel will expand in that same left hand side bar with the options you can choose at this point. You want to choose the option called “Formatter”
- Next you have to tell Formatter what you want it to do. In this case, we want to format phone numbers, so choose the “Numbers” option and click Save + Continue
- Next you’ll tell Formatter what type of number you want to format, which will be phone numbers
- Now you have to tell Formatter which field from Hubspot you want to format, in our case, we want to format the field so click the drop down arrow, search “Phone Number” in the search box, and then click on Phone Number from the drop down
- Next you’ll tell Formatter how you want the phone number formatted, in my case I want nationally formatted numbers so click that option and click continue
- Now Zapier is going to ask you if you want to send a test contact to Hubspot, and in this case it’s too early to do that, so you can just click Skip Test & then click Finish.
- Ok, we’re almost done! All that’s left to do is to send the properly formatted phone number back to Hubspot. This is one of the most important steps. If you don’t do this last step your phone number won’t be updated in Hubspot, which is the only reason that we’re even doing this.
- So once again, click on “Add a Step” from the left hand side bar
- Now select “Action/Search”
- Once again, search “Hubspot”
- Next tell Zapier what you want this step to do. In our case we want it to create or update contact so choose that option and then click “Save + Continue”
-
The next step is just going to verify that your Hubspot account is connected to Zapier, which it is, so you can just click on Save + Continue
-
Since Hubspot uses the email address field as the unique identifier for all contacts, you have to connect the email field in Hubspot to this Zap. Don’t worry, this won’t change anything on the email field in Hubspot at all.
-
Finally, we have to connect the newly formatted phone number in Zapier to the right phone number field in Hubspot. This step is similar to the one above. Search the page for “Phone Number” by simply clicking CTRL + F on your keyboard, type in “phone number” and you should be instantly taken to the phone number field on the page. Then drop down the field options, click on “Numbers” and select “Phone Number” and then “Continue”
- The last step is just to test that everything is working. So as long as you chose a contact in the begining of this tutorial that had an improperly formatted number, when you send a test back to Hubspot you’ll see the phone number get updated in Hubspot. So click on “Send Test to Hubspot”.
- Finally all you have to do is click on Finish and then name the Zap, and turn it on.
CONGRATULAIONS!!! You’re all done finally.
I hope I didn’t miss any important steps and this helps you as much as it has helped me.
Some more things to consider:
- There are more things that you can format with Zapier’s “Formatter” tool. For example, I have another Zap running that converts any contacts first or last name from all capps to capitalized. Like MICKEY MOUSE to Mickey Mouse.
- If you have a free Zapier account, the Zap will only run every 15 minutes. If you pay for an account, it will run every 5 minutes. The way that works is that the Zap runs every 5 minutes regardless of what time the new contact came into Zapier. For example, let’s say the Zap runs at 1:00 pm, 1:05 pm, 1:10 pm etc. Any contact that comes into the system at 1:01 pm won’t be updated for 4 minutes until 1:05 pm, but a contact that comes into the system at 1:04 pm would be updated in 1 minute. But, having said all that, it always seems to me that the Zap runs much faster than that.
If you have any questions, or if I have missed any major steps please let me know and I will do my best to update this tutorial.
Just fair warning, my job keeps me beyond busy so it may take me a long time before I am able to reply.
Good luck!!!
I’m pleased to announce that we have implemented automatic formatting for how phone numbers appear across the CRM, as well as a new “Show country code dropdown” configration option for phone fields in Forms! Any continuing inconsistencies should be brought to the attention of our Support team, and any other phone number related requests should be filed as new ideas. Thanks for your feedback!
Good to see some progress on this.
Though the delivered solution does not solve the problem for the original idea.
We still do not have a way to format phone numbers that are entered internally into hubspot.
Hi @hroberts
Although it is nice that you added that functionality on the front end, it does NOT resolve the current issue/problem posted originally. This Idea has NOT BEEN DELIVERED, so please edit your commeny stating “Any continuing inconsistencies should be brought to the attention of our Support team, and any other phone number related requests should be filed as new ideas.”, Please.
This Idea wholly focuses around being able to provide a clean database for users, not customers. So please change this Idea from Delivered because saying it is, is wholly untrue. Thank you.
Respectfully,
Mx.Lowe
I agree. It is nice to see some updates on this, but what we really need is a way to automatically format all phone numbers in hubspot for every country. This is one of our main issues and every CRM user in the world has this problem. I don’t understand why hubspot doesn’t give this more attention?
Hey guys, we are looking for a similar sollution for Countries and States in Addresses in hubspot.
I’d like to share it here and see if we get some votes.
Global Solution for Addresses: Country + State
I know this is not completely related, but I thought people looking for consistent number formatting would also be interested in consistent address formatting.
Totally agree with you. Thanks for taking the time to tell HubSpot how they can get better, if that’s even possible. But if they execute this - game onnnnn to all us marketing folk. 
Totally agree everyone tooting the horn here. Thanks for taking the time to tell HubSpot how they can get better everybody. This really needs to be looked at. I’m still using microsoft excel spreadsheets to format things. It’s way too outdated. HubSpot has formatting on their forms, but we don’t get the same functions on ours as paid users.
Totally agree - set formatting options are needed!
@hroberts the solution delivered does not fix the problem of this idea, this feature IS NOT delivered. Can you please change the status?
When the community of users create feature request and takes the time to upvote them, it would be great to not have Hubspot throwing everything away by marking things done while they are not. Is this delivered, is this not?
It’s clearly not, below is side by side comparison of the original problem and current behavior of Hubspot.
@VagaeNatus I’m in agreement with you. This idea is not delivered.
@hroberts can we please have an answer here?