From the course: Excel 2016: Tips and Tricks
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Quickly format phone and SS numbers
From the course: Excel 2016: Tips and Tricks
Quickly format phone and SS numbers
- [Voiceover] In this worksheet, we see social security numbers and phone numbers, and for both of these features, there are special built-in formats. So, the data in column A represents how social security numbers might look. These are randomly selected, of course. But we like to see the dashes in there. Now we could type them. That's what was done in column D, but that's extra work. If you're about to put in social security numbers, say we're about to do that in column G. Even before you start, let's format these with that special formal. Ctrl-1 will get us there fast, and, on the Number tab, it's under Special, Social Security Number. Click OK So I'll just make up a number here, a nine-digit number, Enter, and it looks like that. And the same thing with phone number. Phone numbers aren't readable. Now in the United States we use parentheses and dashes; that's going to be different in different countries. Here's the look of phone numbers, and in column E, the open and close…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
-
-
Use keystroke shortcuts for frequently needed numeric formats6m 29s
-
Accentuate data with alignment tools6m 2s
-
Add a color background to every 5th row in a range5m 40s
-
Use conditional formatting based on comparison criteria5m 13s
-
Use conditional formatting to highlight formula cells only2m 54s
-
Create custom formats: Dot leaders and more6m 1s
-
Use special formats for times over 24 hours4m 9s
-
Add/remove strikethrough and borders with keystroke shortcuts3m 34s
-
Quickly format phone and SS numbers3m 54s
-
-
-
-
-