Thread: trying to change 000-000-0000 phone format to (000)000-0000 ????
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mill Mill is offline
external usenet poster
  
Posts: 2
Default trying to change 000-000-0000 phone format to (000)000-0000 ????
Assuming you have the current phone number in cell A2, for instance, the
following could be put into cell B2:
="("&Left(A2,3)&")"&Right(A2,8)

"Labtyda" wrote:

This is from a data base that was given to me. I have tried to format the
cells, but it won't change them. Any suggestions?

thanks,
Jean
Reply With QuoteReply With Quote