function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
ShaTShaT 

Convert a Phone number to Correct Phone Format

Hi,

I have a phone no- +1 2132007307  which i need to convert into (213) 200-7307 this format. 
How can i do this with formula field.

Thanks
ShaT
Best Answer chosen by ShaT
Himanshu ParasharHimanshu Parashar
Hey Sha,

Try following formual

 
IF(Country_Code__c = 1, MID( Phone ,2, 3) &'-'& MID(Phone,7,3)&'-' & MID(Phone,11,4), Phone)