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

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

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" wrote in message
...
How can I change the format of my phone number from 000.000.0000 to one
with
parenthesis like (000)000-0000. Thanks!

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

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" wrote in message
...
How can I change the format of my phone number from 000.000.0000 to one
with
parenthesis like (000)000-0000. Thanks!

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