Social Security Number format

Jean · Mar 7, 2005

How do I change social security numbers to leave out the dashes?

PeterAtherton · Mar 7, 2005

Jean

With a helper column try =SUBSTITUTE(E6,"-","")

Regards
Peter