Skip to main content
Best answer

Trouble formatting phone numbers starting with 4 from Google Sheets with Zapier.


I am trying to format Phone Numbers with a country code when I am extracting them from a google sheet. 
This is working very well for every number exept the ones starting with the number 4. Which leads me to think this is a glitch or bug. 

I have checked the registry for Norway, where phone numbers that starts with 4 are registered which means Zapier should not have a problem formatting them. (Read about this maybe being an issue elsewhere), but for me it seems as tho it’s another problem.

Am I in the wrong here? Or is this an glitch from Zapier?
I will add som pictures so you can see. 

 

Example with a number starting with 4.

 

Example with any other number (the same formatting in Google sheets)

 

Best answer by Troy TessaloneBest answer by Troy Tessalone

Hi @Enkel_Mark 

Good question.

Try changing this field to No.

 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31067 replies
  • Answer
  • November 4, 2023

Hi @Enkel_Mark 

Good question.

Try changing this field to No.

 


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7547 replies
  • November 9, 2023

Hey there, @Enkel_Mark!

Just wanted to check in to see how you got on with Troy’s suggestion here? Let us know if you still need any help on this! 🙂