change phone no. from ###-###-#### to (###) ###-####

  • Thread starter Thread starter KarinS
  • Start date Start date
K

KarinS

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
 
The "numbers" you have are probably text values, so changing the
format of the cell will not affect how they appear. In an adjacent
helper column you could use this formula:

="("&LEFT(A1,3)&") "&RIGHT(A1,8)

and then copy this down as required.

Hope this helps.

Pete
 
Back
Top