If you want text

=TEXT(SUBSTITUTE(A1,"/","-"),"(000)-000-0000")

if you want number just replace (ctrl + H) and replace / with -
then use the built in formatting for US phone numbers


note that in my example your phone number was in A1, adapt accordingly


--
Regards,

Peo Sjoblom



"don" wrote in message
...
How do you convert phone numbers in the following format '000/000-0000 to
the
excel format of (000)000-0000 without retyping each cell. I change the
cells
format to phone numbers with no change in the number.