View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JSM123456 JSM123456 is offline
external usenet poster
 
Posts: 3
Default CONVERT TO (###) ###-####

How do you convert a phone number in this format xxx-xxx-xxxx to (###)
###-####? I've tried format, cells, custom, (###) ###-#### and "(###)
###-####" but neither worked. I can convert to ########## if needed. I
appreciate your help.