Phone number format from 000.000.0000 to (000)000-0000

Janice · 06-23-2005, 04:05 PM

How can I change the format of my phone number from 000.000.0000 to one with
parenthesis like (000)000-0000. Thanks!

**keithl816** · 06-23-2005, 04:52 PM

Right Click Cell to be formatted

Select Format Cells

Click number tab

Click Custom

In the box that shows under Type: enter this

(###)###-####

Click OK

just type in the ten digits in the cell and it will automatically put the () - in it for you

Hope this helps

CLR · 06-23-2005, 05:05 PM

Save your data and use a copy for this exercize...........
Assuming you don't actually have any leading zeros.........
Highlight your column with the phone numbers and do Edit > Replace > in the
"Find what:" box type just a period > in the "Replace with:" box leave it
blank > press the Replace All button...........

Then, highlight the column again and do Right-click > Format cells >
NumberTab > Special > and choose "Phone Number" in the "Type:" window > OK

Vaya con Dios,
Chuck, CABGx3

"Janice" <Janice@discussions.microsoft.com> wrote in message
news:8D7F31B4-F0E9-47EA-B4A2-2C2DE679609C@microsoft.com...
> How can I change the format of my phone number from 000.000.0000 to one
with
> parenthesis like (000)000-0000. Thanks!

Janice · 06-23-2005, 08:05 PM

Thanks Chuck - have a terrific day!

"CLR" wrote:

> Save your data and use a copy for this exercize...........
> Assuming you don't actually have any leading zeros.........
> Highlight your column with the phone numbers and do Edit > Replace > in the
> "Find what:" box type just a period > in the "Replace with:" box leave it
> blank > press the Replace All button...........
>
> Then, highlight the column again and do Right-click > Format cells >
> NumberTab > Special > and choose "Phone Number" in the "Type:" window > OK
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "Janice" <Janice@discussions.microsoft.com> wrote in message
> news:8D7F31B4-F0E9-47EA-B4A2-2C2DE679609C@microsoft.com...
> > How can I change the format of my phone number from 000.000.0000 to one
> with
> > parenthesis like (000)000-0000. Thanks!
>
>
>

Janice · 06-23-2005, 08:05 PM

Thanks Keith!

"keithl816" wrote:

>
> Right Click Cell to be formatted
>
> Select Format Cells
>
> Click number tab
>
> Click Custom
>
> In the box that shows under Type: enter this
>
> (###)###-####
>
> Click OK
>
> Hope this helps
>
>
> --
> keithl816
> ------------------------------------------------------------------------
> keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
> View this thread: http://www.excelforum.com/showthread...hreadid=381743
>
>