Converting cells to numbers
 

I have a spreadsheet with a column of numbers formatted as follows

1111-111-111

I need to omit the - in both places so that I end up with just the digits
formatted as numbers. Any suggestions???

Converting cells to numbers
 

Ctrl-H

Replace - with nothing

--
__________________________________
HTH

Bob

"readystate" wrote in message
...
I have a spreadsheet with a column of numbers formatted as follows

1111-111-111

I need to omit the - in both places so that I end up with just the digits
formatted as numbers. Any suggestions???

Converting cells to numbers
 

Man...that was so easy, I really should have thought about it myself. Thanks
much - you saved me a lot of trouble.

"Bob Phillips" wrote:

Ctrl-H

Replace - with nothing

--
__________________________________
HTH

Bob

"readystate" wrote in message
...
I have a spreadsheet with a column of numbers formatted as follows

1111-111-111

I need to omit the - in both places so that I end up with just the digits
formatted as numbers. Any suggestions???