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