AnsweredAssumed Answered

Formatting phone numbers when dealing with international companies?

Question asked by jgalt on May 10, 2015
Latest reply on May 12, 2015 by TorstenBernhard

I am working on a solution that has contacts with phone numbers from around the world. About 80% of them are US phone numbers and the rest of them are international. Currently there is no consistency to how the numbers are entered. This is what I am trying to clean up.  I also want to implement a system moving forward so there is a uniform appearance to the numbers.

 

I have found some great custom functions that can handle reformatting phone numbers but how do you identify and deal with international numbers? One of the main problems that I am running into is that when user is entering the phone number I don't yet know the country of origin.

Outcomes