Home |
Search |
Today's Posts |
#1
|
|||
|
|||
change ten digits in a cell to include phone # formats
I need to change a cell with ten digits to include the phone number format
characters. Not just in the "view", but in the actual cell. The cell needs to be changed from "1234567890" to "(123) 456-7890", including the space after the area code. I am importing an excel file of phone numbers and the contents need to be exact. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
Can't open doc. Too many different cell formats. | Excel Discussion (Misc queries) | |||
Look for change next blank cell in Range | Excel Worksheet Functions | |||
Cell formats | Excel Worksheet Functions |