Let’s take a look.
Here we have a small list of numbers that need special formatting.
These numbers can be entered manually using approaches we’ve looked at previously.
Special formats aren’t listed in the number formats menu on the ribbon.
To access, select More Number Formats.
Excel generates the required format on the fly.
We can enter the phone number without spaces or parentheses.
The same is true with the social security numberwe only need to enter the number.
Excel will group the numbers and add the hyphens as part of the Special format.
The built-in options for Special formats are useful, but limited.
However, Excel allows you to create your own custom formats as well.
We’ll look at how to do that in a future lesson.
