Best answer

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

  • 4 November 2023
  • 2 replies

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 Tessalone 4 November 2023, 19:49

View original

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

Userlevel 7
Badge +14

Hi @Enkel_Mark 

Good question.

Try changing this field to No.


Userlevel 7
Badge +11

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! 🙂