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

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?
 
J

Joe User

:
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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top