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,

Be

--
Message posted from http://www.ExcelForum.com

0
6/15/2004 3:44:40 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
667 Views

Similar Articles

[PageSpeed] 53

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/
>
>.
>
0
anonymous (74722)
6/15/2004 4:12:28 PM
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/
>>
>>.
>>
>.
>
0
anonymous (74722)
6/15/2004 6:52:43 PM
Reply:

Similar Artilces: