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? |
#2
|
|||
|
|||
change ten digits in a cell to include phone # formats
Assuming your number is in cell A1, enter the following formula in cell b1:
=TEXT(A1,"(000) 000-0000"), copy that formula to for other lines and then copy/paste values and the result will be the text you're looking for. Gary "Judi Mason" wrote: 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? |
#3
|
|||
|
|||
change ten digits in a cell to include phone # formats
Have you tried,
<Format <Cells <Number tab, And click on "Special", and choose "Phone Number" ? -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Judi Mason" <Judi wrote in message ... 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? |
#4
|
|||
|
|||
change ten digits in a cell to include phone # formats
="("&LEFT(A1,3)&") "&MID(A1,4,3)&"-"&RIGHT(A1,4)
Vaya con Dios, Chuck, CABGx3 "Judi Mason" <Judi wrote in message ... 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? |
#5
|
|||
|
|||
change ten digits in a cell to include phone # formats
Sorry, forgot to mention that if you use this formula and then do Copy
PasteSpecial Values, then you will get all the info in the cell without just being "formatted", as you asked............. Vaya con Dios, Chuck, CABGx3 "CLR" wrote in message ... ="("&LEFT(A1,3)&") "&MID(A1,4,3)&"-"&RIGHT(A1,4) Vaya con Dios, Chuck, CABGx3 "Judi Mason" <Judi wrote in message ... 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? |
#6
|
|||
|
|||
change ten digits in a cell to include phone # formats
Thanks so much........very accurate and simple!!
"Gary Rowe" wrote: Assuming your number is in cell A1, enter the following formula in cell b1: =TEXT(A1,"(000) 000-0000"), copy that formula to for other lines and then copy/paste values and the result will be the text you're looking for. Gary "Judi Mason" wrote: 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? |
Reply |
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 |