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.
Have you tried the Find & Replace functionality?
i.e. Select column B, Find "-" and replace with nothing (leave the Replace All option blank)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
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!
Last edited by dmoore702; 12-02-2012 at 08:23 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks