Calculated column to format phone number?

Question

_{Thursday, January 10, 2013 3:56 PM}

Hello, 

I have a phone number field that accepts 10 digits only (no - or spaces).  I want to display it in the (xxx) xxx-xxxx format.  

I found a response on here somewhere about adding a formula to calculated column.  Here is the formula:  

="("&REPLACE([Phone number],4,1,")")

However, that just returns this:  (xxx)xxxxx

It adds a parentheses at the beginning and then replaces my 4th digit with another parentheses.  Can anyone help me with a formula that would INSERT a parenthese and a hyphen?

Thanks so much
Michelle

michelle korb

All replies (2)

_{Thursday, January 10, 2013 6:15 PM ✅Answered | 2 votes}

Try this instead

=TEXT([Phone number],"(000)-000-0000")

Amit

_{Thursday, January 10, 2013 7:30 PM}

thank you!!!!

michelle korb