Prev: excel formula
Next: Same problem.
From: hmsteiner on 28 Dec 2009 12:16
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?
From: T. Valko on 28 Dec 2009 12:23
Use a custom number format of 000-000-0000

--
Biff
Microsoft Excel MVP


"hmsteiner" <hmsteiner(a)discussions.microsoft.com> wrote in message
news:A9B365F3-896D-41C8-8C2C-105C856174F0(a)microsoft.com...
> 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?


From: Joe User on 28 Dec 2009 12:31
"hmsteiner" wrote:
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.
 | 
Pages: 1
Prev: excel formula
Next: Same problem.