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 

Converting Number formulae field to phone formatt ?

I have created a formulae field which displays phone no. But i am getting like  6678894949 some thing like this...

I want to have in a phone formatt. (812)-547-1458. Please help me
Best Answer chosen by
Mario PaesMario Paes
Here's a formula you can use:
'(' & MID( Phone ,2, 3) &')-'& MID(Phone,7,3)&'-' & MID(Phone,11,4)

Also,  if you are using the phone field, then the data is formatted automatically by salesforce as (812) 547-1458