Datasheet

Table 1-1 lists some common format codes and how they affect numbers.
Table 1-1 Number Format Codes
Number Format Code How 16,906,714 Would be Displayed
0, 16907
0,0, 16,907
0.00, 16,906.71
0,”K” 16907K
0,0,”K” 16,907K
0.00,”K” 16,906.71K
$0,0,”K” $16,907K
0,, 17
0,,”M” 17M
0.0,,”M” 16.9M
0.00,,”M” 16.91M
$0.0,,”M” $16.9M
Figure 1-5:
Select
Custom in
the Category
list and
enter a
number
format code
in the Type
input box.
21
Chapter 1: Getting in the Dashboard State of Mind
05_228142 ch01.qxp 1/24/08 9:17 PM Page 21