Format phone and social security numbers

- [Instructor] We're looking at the worksheet called…HR List in our chapter nine file.…Columns D and E are certainly not typical…when you see Social Security numbers nearly always…you see dashes within them,…and in phone numbers you might see periods,…you might see slashes, you might see parenthesis…it's certainly atypical the way we're seeing them here.…Now, let's say maybe somebody had a good idea,…just wasn't finished.…When you type Social Security numbers,…you don't need to type the dashes,…and it wasn't done here but ideally what you should be doing…almost from the beginning, and we can certainly do it now…is apply a special format.…

I'm going to right click on column D,…and go right into Format Cells…on the Number tab, the category Special,…and off to the right Social Security number.…You can double click it or if you select it…and just click OK, watch what happens.…The dashes have been applied, now they're in the format,…in the same way the dollar signs are in the format.…If you click on a cell that's got dollar signs in it,…