Debenture Hide SNN Field For Free

Employers are not permitted to truncate their own Employer Identification Numbers (EINs) on Forms W-2 furnished to employees. In addition, employers may not truncate SSNs on Forms W-2 that are filed with the Social Security Administration or any state or local tax authority.

To do that, highlight just those cells and again open Format Cells and the Protection tab. Be sure the Locked and Hidden boxes are not checked. Click on OK . To hide the column that contains the full Social Security numbers, highlight the column, click Format, Column, Hide .

More importantly, if you Google your social security number and then click on a link, that information is passed along to the site you visit, meaning you will have just handed your social security number to them (though not your name unless you were put that into the search box as well).

A masked SSN is an alternative to using the complete SSN, IRS Individual Taxpayer Identification Number (ITIN), or IRS Adoption Taxpayer Identification Number (ATIN). The masked SSN displays only the last four digits of an individual's identifying number and is shown in the format XXX-XX-1234 or --1234.

Replacing the SSN with a mask on reportsOpen 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 cells that contain sensitive data you want to hide. Right-click to choose Format Cells option from the drop-down menu. On the Number tab, choose the Custom category and enter three semicolons (;;;) without the parentheses into the Type box. Click OK and now the data in your selected cells is hidden.

You may not truncate on any forms filed with the IRS (Copy A) or with state or local governments. You cannot truncate your own identification number. These rules do not apply to Form W-2.