A
B
C
D
E
F
G
H
I
J
1
Number Formats
123456789.12345
2
Format
Positive
Negative Format 1
Negative Format 2
Negative Format 3
Negative Format 4
3
1234
123456789
-123456789
123456789
(123456789)
(123456789)
Col I is hidden -->
4
1234.0
123456789.1
-123456789.1
123456789.1
(123456789.1)
(123456789.1)
This is col J
5
1234.00
123456789.12
-123456789.12
123456789.12
(123456789.12)
(123456789.12)
6
1,234
123,456,789
-123,456,789
123,456,789
(123,456,789)
(123,456,789)
7
1,234.0
123,456,789.1
-123,456,789.1
123,456,789.1
(123,456,789.1)
(123,456,789.1)
8
1,234.00
123,456,789.12
-123,456,789.12
123,456,789.12
(123,456,789.12)
(123,456,789.12)
9
$1,234.00
$123,456,789.12
$-123,456,789.12
$123,456,789.12
($123,456,789.12)
($123,456,789.12)
10
Dates
Times
Percentages
Fonts
11
12/31/2008
11/11/2008 10:55
1/1/09 1:44:59 am
23:00:00
50%
Bold
12
02/03/08
10:55:48 am
1/1/09 1:45:00 am
23:30:00
1.23%
Italic
13
12/31
10:55:48
1/1/09 1:45:01 am
Underline
14
December 31, 2008
12/01/2009
Bold - Italic
15
Wednesday, December 31, 2008
Bold - Underline
16
31-Dec
italic - Underline
17
Colors
18
Red
Green
Blue
Yellow
Gray
Orange
Purple
Cyan
19
20
Format Colors Override Cell Colors:
(444)
444
21
22
Col/Row Spans
Alignment
Font Size
Font Family
23
colspan=3
left
10 point
Times New Roman
24
rowspan=3
colspan=2
center
12 point
Arial
25
colspan=2
rowspan=2
right
16 point
Verdana
26
20 point
Comic Sans MS
27
28
Formulas
29
Boolean:
TRUE
FALSE
30
String:
Test
ABC
31
32
Borders
33
Thick Solid:
left
top
right
bottom
none
all
34
35
Double:
left
top
right
bottom
none
all
36
37
Dashed:
left
top
right
bottom
none
all
38
39
Dotted:
left
top
right
bottom
none
all
40
41
Border Colors:
Red
Green
Yellow
Blue
all
42
43