How to Format Social Security Numbers in Excel
Click on the column in which you are entering one or more SSNs., Right-click and review the dropdown menu that appears., In the Format Cells menu box, select the Special category from the left sidebar., Click on Social Security Number, then press OK.
Step-by-Step Guide
-
Step 1: Click on the column in which you are entering one or more SSNs.
Make sure to select the column letter (at the very top) to highlight the entire section, in which you want to apply this special formatting. -
Step 2: Right-click and review the dropdown menu that appears.
Select "Format Cells..."
Several different types of special information fields will appear in the middle, from which you can select. , The highlighted column will now format SSNs properly, which includes adding dashes between the digits and not omitting any numbers. -
Step 3: In the Format Cells menu box
-
Step 4: select the Special category from the left sidebar.
-
Step 5: Click on Social Security Number
-
Step 6: then press OK.
Detailed Guide
Make sure to select the column letter (at the very top) to highlight the entire section, in which you want to apply this special formatting.
Select "Format Cells..."
Several different types of special information fields will appear in the middle, from which you can select. , The highlighted column will now format SSNs properly, which includes adding dashes between the digits and not omitting any numbers.
About the Author
Beverly Baker
Experienced content creator specializing in DIY projects guides and tutorials.
Rate This Guide
How helpful was this guide? Click to rate: