If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel - Imported Number to Phone Number
Is there a way to change an imported number such as:
7042626598 and display it as a phone number like: (704) 262-6598 ? Thank you, Ben --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Excel - Imported Number to Phone Number
Ben,
Yes you can format the cells containing the 10 digit number to a phone number. Highlight all the required cell and on the Main menu choose Format/Cells/Number/Special/Phone Number Charlie O'Neill -----Original Message----- Is there a way to change an imported number such as: 7042626598 and display it as a phone number like: (704) 262-6598 ? Thank you, Ben --- Message posted from http://www.ExcelForum.com/ . |
#3
|
|||
|
|||
Excel - Imported Number to Phone Number
One more is too do what Charlie says while recording it
into a macro. You will then be able to convert any cell by activating the macro. If you know VBA, you can parse the number on the fly to detect a preceding '1' as in 1- 800 and insert a "-" as well as picking off the xxx-xxxx sequence also allowing for a totally automatic conversion. Kevin -----Original Message----- Ben, Yes you can format the cells containing the 10 digit number to a phone number. Highlight all the required cell and on the Main menu choose Format/Cells/Number/Special/Phone Number Charlie O'Neill -----Original Message----- Is there a way to change an imported number such as: 7042626598 and display it as a phone number like: (704) 262-6598 ? Thank you, Ben --- Message posted from http://www.ExcelForum.com/ . . |
Thread Tools | |
Display Modes | |
|
|