| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Phone Number Formatting
I have phone number data that has been entered into a column as ##########
with no (###)###-#### formatting. I have used format cellsnumbercustom and then entered (###)###-#### to change how the fields are displayed. I'm trying to find a way to modify the base data so that the formatted brackets and dash from the phone number appear in the data not just in the field formatting. I tried pasting values but that didn't work. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number formatting - what's going on? | Excel Discussion (Misc queries) | |||
| Number Formatting | Excel Worksheet Functions | |||
| Alpha Phrase To Phone Number Calculator in excel | Excel Discussion (Misc queries) | |||
| Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) | |||
Threaded Mode
