Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting characters into text already typed
I made a list of phone numbers without the parenthesis and dashes and
spaces figuring I would format the numbers later with the special phone number format. But now I want to actually input all the parenthesis, dashes and etc. into the plain numbers typed in the cells. Any suggestions? Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting characters into text already typed
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting characters into text already typed
Select the cells.....Right-click FormatCells NumberTab Special
PhoneNumber OK Vaya con Dios, Chuck, CABGx3 wrote in message ups.com... I made a list of phone numbers without the parenthesis and dashes and spaces figuring I would format the numbers later with the special phone number format. But now I want to actually input all the parenthesis, dashes and etc. into the plain numbers typed in the cells. Any suggestions? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting an additional line of text within same cell | Excel Worksheet Functions | |||
TEXT CELLS OVER 40 CHARACTERS | Excel Discussion (Misc queries) | |||
how do i step thru a text field looking for 6 numeric characters | Excel Worksheet Functions | |||
Detecting Blanks and Non Text Characters. | Excel Worksheet Functions | |||
REMOVE SPECIAL CHARACTERS FROM TEXT CELLS | Excel Worksheet Functions |