Microsoft Office Tutorials and References
In Depth Information
l The Type box appears
in the dialog box.
7
Type the appropriate
codes to represent your
format.
Use a period (.) for a
decimal point and a
comma (,) to separate
thousands.
Note: See Excel Help for
a complete guide to
codes.
7
8
Click OK.
8
l Your format now appears at the bottom of
the list of Custom format types.
9
To apply the format, select one or more
cells.
0
Repeat Steps 1 and 2 to reopen the
Format Cells dialog box.
9
!
Click Custom.
@
Click your custom format.
!
#
Click OK.
l Excel applies the custom format to the
cells you selected.
@
#
Did You Know?
To use a custom format in another workbook,
copy a formatted cell from the workbook with
the format and paste it into the workbook
without the format. The format then becomes
available in the Format Cells dialog box.
Caution!
Excel correctly applies custom number formats as
long as you type the correct number of digits. For
example, for the format ##-##, if you type too
many digits, Excel correctly places the two
numbers starting from the right but incorrectly
formats the excess digits on the left.
Chapter 10: Customize Excel
229
 
Search JabSto ::




Custom Search