Thread: telephone number format change in Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sherry[_2_] Sherry[_2_] is offline
external usenet poster
  
Posts: 1
Default telephone number format change in Excel
I have telephone numbers that are formatted as (###) ###-####. I need a
formula to change the format to ###-###-####.
Also need the same for telephone numbers that are formatted as # (###)
###-####. Please help.
Reply With QuoteReply With Quote