Microsoft Office Tutorials and References
In Depth Information
As an example, consider U.S. 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 type a phone number with the expected
formatting in a cell, it’s much simpler to type 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 opening the Format Cells
dialog box to the Number page and displaying the formats available for the Special
Clicking Phone Number in the Type list tells Excel to format 10-digit numbers in the
standard phone number format. You can see 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 formatting.
Search JabSto ::

Custom Search