Deleting dashes from Social Security Number

[Echo]

I have a column of social security numbers and I want to delete the dashes between the numbers so the social security number is just 123456789. When I use find and replace it works but if the social security number starts with a 0 I lose that leading zero. Please help.

 

[phantom1975]

You have to convert the SSN to TEXT by putting an apostrophe in front of the zero.

'0030033933

What method are you getting rid of the dashes?

 

[Yogi Anand]

Ok, here we go Echo -- the following modification fixes the problem of numbers beginning with 0 ...

Sub yFixSSnumber()
    For Each cell In [C2:C250]
        cell.Value = WorksheetFunction.Substitute(cell.Value, "-", "")
        cell.NumberFormat = "000000000"
    Next
End Sub
[\CODE]

 

[Echo]

I can't express my thanks enough for all the help and patience. Thank you Thank you.