Say the column of your ########## numbers starts in A1. Type this
formula into B1, and copy it down to the bottom of the column:

="("&LEFT(A1,3)&")"&" "&MID(A1,4,3)&"-"&RIGHT(A1,4)

This will give you (###) ###-####. If you don't want the space, you
can remove the ...&" "& part of the formula.

If you want to get rid of the formulas, copy this new column and paste
special -- values.

Note that this will be text-formatted.


--
Excel_Geek


------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=399052