Formatting a column of telephone numbers in Excel 2007

I have a column of telephone numbers which currently are just displaying as
"8001234567"

is there a way to format this column to 800-123-4567?
moriniaAdvanced Analytics AnalystAsked:
Who is Participating?
 
kgerbConnect With a Mentor Chief EngineerCommented:
Format Cells, Custom, Type

Then use this custom format

###-###-####

Kyle
0
 
Saqib Husain, SyedEngineerCommented:
Select the column
press ctrl-1
select number tab
select custom
use this custom string:    ###-###-####
click on OK
0
 
mustang83Commented:
yes you can use the formula :

=LEFT(A2,3)&"-"&MID(A2,4,3)&"-"&MID(A2,7,4)

Just change A2 to the cell which holds the telephone number. Then hide the cell which holds the unformatted number.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.