+ 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 anvesh@force.com
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