Remove dash (-) that resides between numbers in a SSN

[wheatgrass]

I have a column of about 600 names that starts in cell B2 and goes down to cell B600. Presently the SSN is showing in each cell as 111-11-1111. I want it to show as 111111111 but not sure how to remove the - between the numbers. Any help would greatly be appreciated.

[Richard Buttrey]

Have you tried the Find & Replace functionality?

i.e. Select column B, Find "-" and replace with nothing (leave the Replace All option blank)

[dmoore702]

Go to one of the cells that has the social in it and right click to format cells (or command 1). My sheet has it listed under Special and Social Security number, if I change that to general (first option), it leaves the number with no dashes. Good luck!

If it works for one, I would assume you could highlight the entire column, format to general and voila!