View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Don Don is offline
external usenet poster
 
Posts: 487
Default Converting Phone Numbers

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.