microsoft excel
 

how do you change telephone numbers ie. (555) 123-1234 to 5551231234

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

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

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

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