Select your phone numbers, and do 3 Find/Replaces, replacing "(" with
nothing, ")" with nothing, and "-" with nothing.

In article ,
Delaina wrote:

Hello-
I have a report for work that I have to do today and on the spreadsheet
there are phone numbers that were entered on a spreadsheet as
(###)###-#### I need to reformat the numbers w/out the special
characters. I tried custom format and that didn't work. I tried a
formula and that didn't work..so basically I need my phone numbers in
the spread sheet to look like this ##########. Is there a way to do
that?
Thanks,
Delaina