| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
display USA phone format in formula bar
Excel 2003
I have lists of phone numbers in continuous 10 digits format. I'd like to convert them to USA format so I can import them (with area code in parentheses etc) into a PTA school phone directory using Word 2003 merge. I know about Format/Cells/Special/Phone Number but this is obviously only for display and printing purposes. While the cells show the US format, the unformatted 10 digits are still in the formula bar. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format a cell to display as all caps | Excel Discussion (Misc queries) | |||
| Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
| I Need a Formula to Auto-fill Phone Numbers in a Range | Excel Worksheet Functions | |||
| display only one formula | Excel Discussion (Misc queries) | |||
| Modifying a formula to display the results of another formula | Excel Worksheet Functions | |||
Threaded Mode
