Microsoft Office Tutorials and References
In Depth Information
CUSTOM NUMBER FORMAT
Excel provides many formats for presenting numbers,
dates, times, currencies, and other types of information
involving numerals. You can use these formats or you
can create custom formats for specific purposes. For
example, you may want to include the letters SSN
before Social Security numbers or include an area code
in parentheses before a telephone number.
Creating formats requires you to use number codes.
Common codes include 0 or # to stand for any digit.
Use 0 if you want Excel to enter a 0 when the user
does not type another number. Use # when you only
want the digit typed to appear. To represent a Social
Security number, use the code 000-00-0000. For a
phone number with area code, type (000) 000-0000.
When using one of these examples, type numbers
into the cell with the custom format; Excel adds the
dashes and parentheses automatically. To code text,
simply place the text in quotes: for example, “SSN”
Click the Home tab.
Click the Number group
The Format Cells dialog box
Click the Number tab.
Click a category with formats
similar to the one you want to
Click a format type similar to the
one you want to create.