Letter Hide SNN Field For Free

Criminal records Once someone has used your Social Security number to find out information on your name and address history, they can use that information to determine if you have a criminal background. Prospective employers often do such background checks.

To hide the column that contains the full Social Security numbers, highlight the column, click Format, Column, Hide . Now the final step is to password protect the worksheet so the formula is both hidden and protected and the full Social Security numbers are hidden. Click on Tools, Protection, Protect Sheet .

Before 2011, assigned Social Security numbers were based on when and where people were born.The Social Security Administration didn't switch to random number assignments until 2011, meaning a fraudster can steal your identity using your state, date of birth, and the last four digits.

Open the report. Click the Columns tab. Under Columns, find the row for the Social Security Number and click on it. Find the section titled Format, and click the ellipses. Select Special as the Category. Select Social Security Number Mask as the Type. Click OK.

A Social Security number can be used to steal your identity (commonly called identity theft) to commit fraud, open new credit and bank accounts, get medical care/other benefits and obtain employment.

The letters at the end of a SSN indicate the claim number for a SSI or Social Security beneficiary. Per the SSA: "If you are an SSI beneficiary, your claim number is your nine-digit Social Security Number (SSN) (000-00-0000) followed by two letters such as EI, DI, DS, DC.

Select a blank cell, here I select the Cell G1, and type this formula =LEFT(E1,3) (E1 is the cell you want to extract the first 3 characters from), press Enter button, and drag fill handle to the range you want. Then you see the first 3 characters are extracted.