View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KarinS KarinS is offline
external usenet poster
 
Posts: 1
Default change phone no. from ###-###-#### to (###) ###-####

I have phone numbers I exported into an Excel spreadsheet. When I reformat
the cell to a custom phone number format it doesn't change it. However if I
retype straight numbers it displays correctly. Is there a way to change from
###-###-#### to (###) ###-####? Thank you