Thread: trying to change 000-000-0000 phone format to (000)000-0000 ????
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gaurav[_2_] Gaurav[_2_] is offline
external usenet poster
  
Posts: 207
Default trying to change 000-000-0000 phone format to (000)000-0000 ????
I know there can be better answer than this one. but this one works.

suppose the number is in A1. In B1, write
="("&LEFT(A1,3)&")"&MID(A1,5,3)&RIGHT(A1,5)

drag it down all the way down. once done, COPY the entire column and PASTE
SPECIAL VALUES.


"Labtyda" wrote in message
...
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