Try this:

format a column as Special==(Locale) US=Phone Number

and then put the following in column and copy down:

=VALUE(SUBSTITUTE(A1,"-",""))

A1=123-456-7890 etc

Copy/paste special=values when complete

"JSM123456" wrote:

How do you convert a phone number in this format xxx-xxx-xxxx to (###)
###-####? I've tried format, cells, custom, (###) ###-#### and "(###)
###-####" but neither worked. I can convert to ########## if needed. I
appreciate your help.