Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formating phone numbers in cells
Our office recently changed the format we use for phone numbers - from dashes to periods. I want to make a custom format for cells so that even if I slip and use dashes in the phone number, Excel will know to display the phone number with periods. I can't find the way to type the format so that Excel will accept it and to make the changes. Any help would be appreciated! -- jloughmiller ------------------------------------------------------------------------ jloughmiller's Profile: http://www.excelforum.com/member.php...o&userid=36502 View this thread: http://www.excelforum.com/showthread...hreadid=562615 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Phone Numbers in a Merged Cells... | Excel Discussion (Misc queries) | |||
Hightlighting Numbers & then all Cells to the right of these Numbers. | Excel Worksheet Functions | |||
How to alter data on HTML webpage into Excell cells as numbers? | New Users to Excel | |||
Cells formated as numbers are calculating like text | Excel Discussion (Misc queries) | |||
I Need a Formula to Auto-fill Phone Numbers in a Range | Excel Worksheet Functions |