Microsoft Office Tutorials and References
In Depth Information
Formatting numbers
Table 9-2 lists the built-in formats and indicates how these codes relate to the other
categories on the Number tab. (This table does not list date and time codes, which are covered
in Chapter 15.)
TABLE 9-2 Built-in custom format codes
Category
Custom format codes
0
Digit
General
No specific format
Number
0
0.00
#,##0
#,##0.00
#,##0_);(#,##0)
#,##0_);[Red](#,##0)
#,##0.00_);(#,##0.00)
#,##0.00_);[Red](#,##0.00)
Currency
$#,##0_);($#,##0)
$#,##0_);[Red]($#,##0)
$#,##0.00_);($#,##0.00)
$#,##0.00_);[Red]($#,##0.00)
Percentage
0%
0.00%
Scientific
0.00E+00
##0.0E+0
Fraction
# ?/?
# ??/??
Date
(See Chapter 15.)
Time
(See Chapter 15.)
Text
@
Accounting
_($* #,##0_);_($* (#,##0);_($* "-"_);_(@_)
_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)
_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)
_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)
Creating four-part formats Within each custom format definition, you can specify
completely different formats for positive, negative, zero, and text values. You can create
custom formats with as many as four parts, separating the portions by semicolons—positive
Search JabSto ::




Custom Search