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

G

Guest

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

CLR

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
 
K

keithl816

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
 
G

Guest

Thanks Chuck - have a terrific day!

CLR said:
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
Click to expand...
 

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

Similar Threads

Converting Phone Numbers 4
How can I reformat the phone numbers? 1
Column display-excel 2007 2
how to put dashes in a number 13000000000 to 1300-000-0000 2
Phone number formats 2
Matching data 2
Format text box with check box 1
Can I delete a portion of cell contents repeating in multiple fie. 1

Top