If the cells are formatted using the special Phone Number format

[<=9999999]###-####;(###) ###-####

and assuming there is 3 digit area code so your numbers currently look
like:

(781) 555-4444

You can change the format to:

#######

This will result in 7815554444.

If you are not using an area code 555-4444 it will result in 5554444

Just select the entire column, change the cell format and they should
all change.

Not sure how to do it if they were not formatted as the Special Phone
Number format.


Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=482002