| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
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! |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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! |
|
#5
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| default number format | Excel Discussion (Misc queries) | |||
| Custom number format always defaults last number to 0. | Excel Discussion (Misc queries) | |||
| why does currency format change to number format? | Excel Discussion (Misc queries) | |||
| excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) | |||
| Import Indian Rupees as a number format in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
