Other options...

Select the range to fix
Use Edit|Replace
what: - (hyphen)
with: (leave blank)
replace all

This will drop the leading 0's, too.

But you could use a custom format of: 000000000
so the data looks nice.

You could also use a formula in another cell (or column of cells):
=substitute(a1,"-","")
(and drag down)

This will keep the leading 0's and the values will be text.

Andre F wrote:

I am trying to remove the hyphen from between social security numbers;I'm
able to do so using the 'text to column' function, but I am having a problem
with those numbers that are preceded by 0's eg : 001-23-0077 the function is
dropping the zero's and returning 1-23-77....

--

Dave Peterson