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

[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

 

[Pete_UK]

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