Activating formatting tools - two quick methods

- We're looking at a worksheet called Formatting Tools.…Keep in mind that on the Home tab in the ribbon,…they're lots of formatting buttons.…Nearly half of this screen is filled up with a number…of formatting options, but not all formatting options…are visible and sometimes we need to go behind the scenes.…The social security numbers in Column D…don't look as good as the could.…We need to add dashes to them…and we can do it by way of formatting.…How do we get there?…I'm going to click Column D.…The option is not available on the Home tab,…so I'll press cmd+1.…

It activates the Format Cells dialogue box…and many times like this one it doesn't necessarily…go to the tab that we want to go to.…I'm gonna go to the Number tab here, so I'll click it.…And there is a special option here under the Categories,…Special for Social Security Number.…I'll simply double-click it and now we see the dashes.…Now at other times we might wanna use this feature…in a different kind of way, but almost the same way.…I also want to adjust the Phone column.…