You can't do it with just formatting. You have to do a series of
Replace statements to get rid of the unwanted characters. E.g.,

Dim S As String
S = "(505) 555-1234"
S = Replace(S, "(", "")
S = Replace(S, ")", "")
S = Replace(S, " ", "")
S = Replace(S, "-", "")
Debug.Print S


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"childothe1980s" wrote
in message
...
Hello:

If you have a phone number in an Excel field appearing as, say,
(555)555-5555 how can you format it to read one set of numbers
like
5555555555?

Thanks!

childofthe1980s