Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to change Phone Number format | Excel Discussion (Misc queries) | |||
Format change of phone number | Excel Discussion (Misc queries) | |||
How do I change phone numbers from "xxxxxxxxxx" to "xxx-xxx-xxxx | Excel Worksheet Functions | |||
change format for phone numbers automatically | Excel Worksheet Functions | |||
insert a space in a phone #. change (123)456-7890 to (123) 456-78 | Excel Worksheet Functions |