| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
microsoft excel
how do you change telephone numbers ie. (555) 123-1234 to 5551231234
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
microsoft excel
Edit|replace a few times...
select your range edit|replace what: ( with: (leave blank) replace all edit|replace what: ) with: (leave blank) replace all edit|replace what: (spacebar) with: (leave blank) replace all Then format the cell the way you like: custom: 0000000000 or special??? buccig wrote: how do you change telephone numbers ie. (555) 123-1234 to 5551231234 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
microsoft excel
FORMAT, CELL , GENERAL
"Dave Peterson" wrote: Edit|replace a few times... select your range edit|replace what: ( with: (leave blank) replace all edit|replace what: ) with: (leave blank) replace all edit|replace what: (spacebar) with: (leave blank) replace all Then format the cell the way you like: custom: 0000000000 or special??? buccig wrote: how do you change telephone numbers ie. (555) 123-1234 to 5551231234 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
microsoft excel
Only if those numbers were given that special formatting to begin with.
will A wrote: FORMAT, CELL , GENERAL "Dave Peterson" wrote: Edit|replace a few times... select your range edit|replace what: ( with: (leave blank) replace all edit|replace what: ) with: (leave blank) replace all edit|replace what: (spacebar) with: (leave blank) replace all Then format the cell the way you like: custom: 0000000000 or special??? buccig wrote: how do you change telephone numbers ie. (555) 123-1234 to 5551231234 -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
microsoft excel
You are right Dave, I am assuming that this is problem, otherwise I would
follow your suggestion. "Dave Peterson" wrote: Only if those numbers were given that special formatting to begin with. will A wrote: FORMAT, CELL , GENERAL "Dave Peterson" wrote: Edit|replace a few times... select your range edit|replace what: ( with: (leave blank) replace all edit|replace what: ) with: (leave blank) replace all edit|replace what: (spacebar) with: (leave blank) replace all Then format the cell the way you like: custom: 0000000000 or special??? buccig wrote: how do you change telephone numbers ie. (555) 123-1234 to 5551231234 -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Installing: Microsoft Excel Feature | Excel Discussion (Misc queries) | |||
| Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) | |||
| Microsoft Excel is waiting for another application to complete an OLE action | Excel Discussion (Misc queries) | |||
| Excel instance used with "Export to Microsoft Excel" option in Internet Explorer | Excel Discussion (Misc queries) | |||
| Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel | |||
Hybrid Mode
