Try something like this:

For a phone number in A1
B1: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"(",""),")"," "),"-","")

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"childothe1980s" wrote:

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