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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to change phone format ***-***-**** to 1**********
I think you can format numbers to telephone numbers by selecting them, click
on Format, Cells, Numbers, under Category select special, and under Type select Phone Number. Good luck with it! "Dale" wrote: 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 |
#3
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 |