Help converting a 10 digit number 2223334444 to 222-333-4444

  • Thread starter Thread starter hmsteiner
  • Start date Start date
H

hmsteiner

In MS Excel (2007) I have a very long column with 10 digit numbers that need
to be changed to a telephone number with dashes. Can anyone help?
 
:
Subject: Help converting a 10 digit number 2223334444 to 222-333-4444
In MS Excel (2007) I have a very long column with
10 digit numbers that need to be changed to a
telephone number with dashes.
Click to expand...

If you just want to change the appearance, try a Custom format like
000-000-0000.

If you want to change the cell contents to text, try enter
=TEXT(A1,"000-000-0000") into some cell, copy, and paste-special-value back
to A1.

PS: In the future, please copy details in the Subject line into the body of
your message. Some NG readers do not display the entire subject line, in
particular the MS Discussion Groups interface that you use.
 
Back
Top