change xxxxxxxxxx to xxx-xxx-xxxx?

[Rashed]

I have large quantity phone numbers in this format 2392617177, and I like to
change all the phone number to this 239-261-7177 format. How can I do it
quickly? Please help….

[JulieD]

Hoping all your phone numbers are in a column ... if so insert a column to
the right of these numbers and in the first cell type
(assuming phone numbers start in A2)
=LEFT(A2,3)&"-"&MID(A2,4,3)&"-"&RIGHT(A2,4)

and fill down (move cursor over bottom right hand corner of the cell until
you see a + and then double click)
now when you're happy that the numbers are correct -
now select this column and choose copy
select your old column and choose
edit / paste special / values

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Rashed" <Rashed@discussions.microsoft.com> wrote in message
news:523B7339-81DF-415C-B792-2AC41A972DE6@microsoft.com...
>I have large quantity phone numbers in this format 2392617177, and I like
>to
> change all the phone number to this 239-261-7177 format. How can I do it
> quickly? Please help..

[mav384]

You could also use the text() command.
Ex:
A__________B
1234567890 =text(A1,"###-###-####")
2345678901 =text(A2,"###-###-####")
3456789012 =text(A3,"###-###-####")

Or in Format cells, under custom you can put ###-###-#### (without quotes).

[pikapika13]

Why isn't formatting to phone number an option?
Format>>>cells>>>number>>>Special>>>Phone number

[MrT]

slect the numbers, right click -> Format Cells. In Category: go to custom and
type in the mask 000-000-0000.

Have Fun !

"Rashed" wrote:

> I have large quantity phone numbers in this format 2392617177, and I like to
> change all the phone number to this 239-261-7177 format. How can I do it
> quickly? Please help….

[CLR]

Just for a different way........
If your numbers are in columnA, make sure columns B and C are empty, then,
highlight column A, do Data > TextToColumns > FixedWidth > set the column
breaks after the third and sixth digits > Finish.........this puts 239 in
cell A1, 261 in cell B1 and 7177 in cell C1..........then in D1 put this
formula and copy down.......
=A1&"-"&B1&"-"&C1

Vaya con Dios,
Chuck, CABGx3



"Rashed" <Rashed@discussions.microsoft.com> wrote in message
news:523B7339-81DF-415C-B792-2AC41A972DE6@microsoft.com...
> I have large quantity phone numbers in this format 2392617177, and I like
to
> change all the phone number to this 239-261-7177 format. How can I do it
> quickly? Please help..

[Qwerty]

You can try changing the format of the cells in Format Cells/Number
tab/Special/Phone Number. Choose English (Canada) under Locale: for the
format you want.

"JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote in message
news:ugaH0qEQFHA.1884@TK2MSFTNGP15.phx.gbl...
> Hoping all your phone numbers are in a column ... if so insert a column to
> the right of these numbers and in the first cell type
> (assuming phone numbers start in A2)
> =LEFT(A2,3)&"-"&MID(A2,4,3)&"-"&RIGHT(A2,4)
>
> and fill down (move cursor over bottom right hand corner of the cell until
> you see a + and then double click)
> now when you're happy that the numbers are correct -
> now select this column and choose copy
> select your old column and choose
> edit / paste special / values
>
> --
> Cheers
> JulieD
> check out www.hcts.net.au/tipsandtricks.htm
> ...well i'm working on it anyway
> "Rashed" <Rashed@discussions.microsoft.com> wrote in message
> news:523B7339-81DF-415C-B792-2AC41A972DE6@microsoft.com...
>>I have large quantity phone numbers in this format 2392617177, and I like
>>to
>> change all the phone number to this 239-261-7177 format. How can I do it
>> quickly? Please help..
>
>

[mav384]

That puts it in (###)###-#### format. He stated that he wanted ###-###-####. I just assumed that is what he wanted.