IOU Add SNN Field For Free

To do this, you can do one of two things:Format the column as Text. Select your data range and press Ctrl+1 to launch the Format > Cells dialog. On the Number tab, click Text.Use the apostrophe character. You can type an apostrophe (') in front of the number, and Excel will treat it as text.

A Social Security number (SSN) is a nine-digit number that the U.S. government issues to all U.S. citizens and eligible U.S. residents who apply for one. The government uses this number to keep track of your lifetime earnings and the number of years worked.

1: Social Security number format: As shown in Figure 3, press Ctrl-1 to display the Format Cells dialog box. Choose Special, and then double-click on Social Security number. The values in the worksheet cells are numbers, but Excel displays them as if they were text with dashes in between the three sets of numbers.

Structure. The Social Security number is a nine-digit number in the format "AAA-GG-SSSS".

The Social Security number is a nine-digit number in the format "AAA-GG-SSSS".

A Social Security Number (SSN) consists of nine digits, commonly written as three fields separated by hyphens: AAA-GG-SSSS. The first three-digit field is called the "area number". The central, two-digit field is called the "group number". The final, four-digit field is called the "serial number".

Some colleges and schools use Social Security numbers as student identification numbers. If you don't have a Social Security number, the college or school should be able to give you another identification number. Social Security numbers generally are assigned to people who are authorized to work in the United States.