Letter Remove SNN Field For Free

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.

Select the data list you want to add hyphens, and click Data > Text to Columns. In the first step of Convert Text to Columns wizard, check Delimited option, and click Next > to step 2 of the Wizard, and check Space option under Delimiters section.

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 .

Select the date cells you will remove the dashes, slashes, or hyphens from, right click, and select Format Cells from the context menu. 2. In the Format Cells dialog, under the Number tab, click to activate Custom in the Category list box, type the date code mmddyyyy into the Type box, and click the OK button.

Find and Replace method. Select the data containing the Social Security numbers, then from the Home tab's Editing group, click on Find & Select and select Replace. Enter a hyphen in the Find what text box and leave the Replace with text box blank. Click the Replace All button.

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.

=SUBSTITUTE(A2,-,) The SUBSTITUTE function always returns text (rather than numbers) so it solves the leading zero problem. You can also very easily fill down the formula to remove hyphens from as many numbers as you need.

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 .

Select 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 Cells2026 On the Format Cells window select Text under the Number tab and click OK.

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.