Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to change phone format ***-***-**** to 1**********
I am new to excel and I have a database that I am trying to convert to a
contact list. The phone number format is not compatable. I tried the "auto correct" option in Tools after highlighting my column of numbers as well as the "find/replace" option under editing. Neither worked. Thanks Dale |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to change Phone Number format | Excel Discussion (Misc queries) | |||
How do I change Phone: 8153381667 to Phone: 815-338-1667 | New Users to Excel | |||
trying to change 000-000-0000 phone format to (000)000-0000 ???? | Excel Worksheet Functions | |||
Format change of phone number | Excel Discussion (Misc queries) | |||
change format for phone numbers automatically | Excel Worksheet Functions |