=SUBSTITUTE(A1,"-","")

and format as 0000000000

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"catrose" wrote in message
...
How do I remove the dashes from SSN's on a spread sheet? They are NOT
setup
as '111-11-1111 I also have a lot of SSN's that start with
00X-XX-XXXX
and I still need the 0's (zeroes) to show.