Microsoft Office Tutorials and References
In Depth Information
Making numbers easier to read
As an example, consider US phone numbers. These numbers are 10 digits long and have a
3-digit area code, a 3-digit exchange, and a 4-digit line number written in the form ( ### )
### - #### . Although it’s certainly possible to enter a phone number with the expected
formatting in a cell, it’s much simpler to enter a sequence of 10 digits and have Excel change
the data’s appearance.
You can tell Excel to expect a phone number in a cell by displaying the Number page of the
Format Cells dialog box and displaying the formats available for the Special category.
Clicking Phone Number in the Type list tells Excel to format 10-digit numbers in the
standard phone number format. You can view this in operation if you compare the contents
of the active cell and the contents of the formula box for a cell with the Phone Number