Excel - Imported Number to Phone Number

B

benallred99

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
 
C

Charlie

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
 
K

Kevin K.

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
 
Top