IOU Insert SNN Field For Free

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.

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".

Click the corner of the cell, with the "+" sign still showing, and drag the cursor down through the column until you reach the cell to the right of the last Social Security number in the list. Release the cursor, and the remaining SSNs will appear without hyphens.

Finding Your Social Security Number If you have a Social Security Number, you can find it on your Social Security card. Some other places that you can find your SSN are on tax returns, W-2s and bank statements. You may even find it on previously filed USCIS forms.

Use the Format Cells option to convert number to text in ExcelSelect the range with the numeric values you want to format as text.Right click on them and pick the Format Cells2026 option from the menu list. Tip. You can display the Format Cells2026On the Format Cells window select Text under the Number tab and click OK.Oct 10, 2014

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.

Do I need to use dashes in the Social Security Number (SSN) field when reporting my employees? No, do NOT use any dashes, just the nine-digit SSN of the employee.