Microsoft Office Tutorials and References
In Depth Information
Creating Custom Cell Formats
You needn’t start with a blank slate when creating custom formats. Select the Custom
category to display a long list of ready-made formats, including some you won’t find in other
categories. In general, it’s easier to start with a format that’s close to the one you want than
to start from scratch. The Type box includes the codes for the format you previously chose
in one of the other categories. In Figure 14-3, for example, we started in the Currency
category, changed the currency symbol to the U.K. pound, and then lipped to the Custom tab
to review and edit the code for that format.
Figure 14-3 Edit the contents of the Type box to add a new custom format. The list below it
contains all available custom formats. Note the Sample box, which previews the custom format.
Custom formats use codes that define how to display digits, decimal places, dates, times,
and currency symbols.
Each custom format can include up to four groups of these codes, separated by semicolons.
The four groups define, in order, the display formats for positive numbers, negative
numbers, zero values, and text. If you enter only one section, that format applies to all numbers
you enter. If you enter two sections, the first set of codes applies to positive numbers and
zero values and the second to negative numbers. If you want to skip a format option (spec-
ifying formats only for positive numbers and zero values, for example), insert a semicolon
for each skipped section.
To specify a color for any section, enclose the name of one of the following eight permitted
colors in brackets: black, green, white, blue, magenta, yellow, cyan, red. The color must be