| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to change phone format ***-***-**** to 1**********
will this work?
="1" & SUBSTITUTE(A1,"-","") -- Gary Keramidas Excel 2003 "Dale" wrote in message ... 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 |
| Reply |
| 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 | |||
![Gary Keramidas[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
