how to reformat numbers

  • Thread starter Thread starter C.Loner
  • Start date Start date
C

C.Loner

I have numbers entered as social security numbers I need to remove the
dashes. I have tried reformatting the cells but that doesn't work example
336-04-0000. How do I convert to just 33604000. I have thousands of numbers.
I am using microsoft
 
Edit....find........ replace

find what...........-........
replace with .....leave this blank.
 
Thank you sooo much!! After spending hours on trying to figure this out, I
was able to complete the task in minutes.
 
Back
Top