Microsoft Office Tutorials and References
In Depth Information
The four entries in this category of the Format Cells dialog box (shown here) are useful
mostly for address and contact lists created in the United States. They allow you to quickly
enter ZIP Codes, phone numbers, and Social Security numbers in any format and without
punctuation. Excel handles the work of adding hyphens and splitting the entered values
into groups of the correct length.
Even if you never use any of these formats, they’re worth studying as examples of how to
build your own cell formats for automatic formatting, a topic we cover in full in “Creating
Custom Cell Formats” on page 459.