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

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

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

On Jan 8, 12:14*am, KarinS wrote:
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

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

Use Excel's Search/Replace function to strip out the extra characters.

Highlight the entire column of phone numbers
First Search/Replace for ( and replace with nothing
Then Search/Replace for ) and replace with nothing
Then Search/Replace for - and replace with nothing.

When you finish that last Search/Replace, the cells should immediately
display in your custom Phone Number format, assuming you had applied
that format previously. If not, apply it now.

KarinS;172765 Wrote:
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


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=47848