Page 440 - Excel 2013 All-in-One For Dummies

422 Information, Please . . .
Table 6-2
Text Value
“G” “F0” “,0” “F2”
“,2” “C0” “C0-” “C2” “C2-” “P0” “P2” “S2” “G” “D4” “D1” “D2” “D3” “D5” “D7” “D6” “D9” “D8”
Text Values Returned by the “format” info_type
Number Formatting
General
0
#,##0
0.00
#,##0.00
$#,##0_);($#,##0) $#,##0_);[Red]($#,##0) $#,##0.00_);($#,##0.00) $#,##0.00_);[Red]($#,##0.00) 0%
0.00%
0.00E+00
#?/?or#??/??
m/d/yy or m/d/yy h:mm or mm/dd/yy d-mmm-yy or dd-mmm-yy
d-mmm or dd-mmm
mmm-yy
mm/dd
h:mm AM/PM
h:mm:ss AM/PM
h:mm
h:mm:ss
For example, if you use the CELL function that specifies “format” as the info_type argument on cell range A10:C28 (which you’ve formatted with the Comma style button on the Formula bar), as in the following formula
=CELL(“format”,A10:C28)
Excel returns the text value “,2-” (without the quotation marks) in the cell where you enter this formula signifying that the first cell uses the Comma style format with two decimal places and that negative values are displayed in color (red) and enclosed in parentheses.