I am trying to format a column of cells that have Social Security Numbers typed WITH the dashes, to have the SS#'s WITHOUT the dashes. Add your answer. Source. Submit Cancel.
https://answers.yahoo.com/question/index?qid=20080723063234AAjSUlw
In the United States, a Social Security number (SSN) is a nine-digit number issued to U.S. citizens, permanent residents, and temporary (working) residents under section 205(c)(2) of the Social Security Act, codified as 42 U.S.C. § 405(c)(2) .
https://en.wikipedia.org/wiki/Social_Security_number
Select cell D6 and type: =TEXT(C6,”000-00-0000″). After hitting enter, it will show the number as 400-39-3687. To apply this formula to the rest of the numbers, drag the cell D6 down to D12 and it will automatically add the dashes to each social security number so you don’t have to retype the formula.
http://exceltemplates.net/introduction/format-social-security-numbers/
The number is issued to an individual by the Social Security Administration, an independent agency of the United States government.
https://en.wikipedia.org/wiki/Social_Security_number
Click on the column with the SSNs in, and then to format cells, if it highlights SSN in a dialogue box, you can click on numbers and set to no decimal places, and then OK. this will remove the dashes.
https://answers.yahoo.com/question/index?qid=20080723063234AAjSUlw
Learn how to format social security numbers in Excel spreadsheets by adding the appropriate dashes in the numbers to make them easier to read. When importing data such as social security numbers, they may come in without dashes, making them harder to read. This also may prevent you from easily extracting just the last 4 digits of each number. With our example sheet, you can learn how to easily format social security numbers to contain dashes. Download the example spreadsheet to learn this formula. In your example sheet, you have a list of employee names and their social security numbers without dashes.
http://exceltemplates.net/introduction/format-social-security-numbers/
I am trying to format a column of cells that have Social Security Numbers typed WITH the dashes, to have the SS#'s WITHOUT the dashes. Update: (i.e. The SS#'s have ALREADY been typed with the dashes; I want to get rid of the dashes). Follow. 4 answers 4. Report Abuse.
https://answers.yahoo.com/question/index?qid=20080723063234AAjSUlw
Details. If the value is missing, SAS writes nine single periods with dashes between the third and fourth periods and between the fifth and sixth periods. If the value contains fewer than nine digits, SAS right aligns the value and pads it with zeros on the left.
http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/a000205197.htm
The Social Security number is a nine-digit number in the format AAA-GG-SSSS. The number is divided into three parts. The Area Number, the first three digits, is assigned by geographical region.
https://en.wikipedia.org/wiki/Social_Security_number
Although its primary purpose is to track individuals for Social Security purposes, the Social Security number has become a de facto national identification number for taxation and other purposes. A Social Security number may be obtained by applying on Form SS-5, Application for A Social Security Number Card.
https://en.wikipedia.org/wiki/Social_Security_number
how format numbers as social security format
The format numbers of  social security format are the number is divided into three parts the Area Number, the first three digits, is assigned by geographical region.