Formats

1/1/00	12/14/95	2/28/00			12/30/00	12/31/00			Unformatted Dates &
1	35047	36584			36890	36891			their Julian number

9/24/99	25-Sep-99	9/26	Sep-99		September-99	September 29, 1999	30-Sep		Dates

9:00 AM	10:00:00 AM	11:00	12:00:00		01:00	1:02:00	03:00.5		Time

1	1.2	1.23	1.234		-1	-1.2	-1.23	-1.234	General

1.00	1.20	1.23	1.23		-1.00	-1.20	-1.23	-1.23	Number

1000000.00	1000000.20	1000000.23	1000000.23		-1000000.00	-1000000.20	-1000000.23	-1000000.23	Number - Big Numbers

1,000,000.00	1,000,000.20	1,000,000.23	1,000,000.23		-1,000,000.00	-1,000,000.20	-1,000,000.23	-1,000,000.23	Number - Big Numbers with comma

$1.00	$1.20	$1.23	$1.23		-$1.00	-$1.20	-$1.23	-$1.23	Currency

$10,000.00	$12,000.00	$12,300.00	$12,340.00		-$10,000.00	-$12,000.00	-$12,300.00	-$12,340.00	Currency - Big Numbers

1.00%	1.20%	1.23%	1.23%		-1.00%	-1.20%	-1.23%	-1.23%	Percentage 2 decimals - small numbers

100.00%	120.00%	123.00%	123.40%		-100.00%	-120.00%	-123.00%	-123.40%	Percentage 2 decimals - bigger numbers

100%	120%	123%	123%		-100%	-120%	-123%	-123%	Percentage no decimals

1.00E+00	1.20E+00	1.23E+00	1.23E+00		-1.00E+00	-1.20E+00	-1.23E+00	-1.23E+00	Scientific

$ 1.00	$ 1.20	$ 1.23	$ 1.23		$ (1.00)	$ (1.20)	$ (1.23)	$ (1.23)	Accounting

$ 10,000.00	$ 10,000.20	$ 10,000.23	$ 10,000.23		$ (10,000.00)	$ (10,000.20)	$ (10,000.23)	$ (10,000.23)	Accounting - Big Numbers

1	1 1/5	1 2/9	1 1/4		-1	-1 1/5	-1 2/9	-1 1/4	Fraction

0.000000000000000000001234567890					1234567890.1234500000000000				Max Precision Numbers

$ 12.34	$ 123.40	$ 1,234.00	$ 12,340.00	$ 123,400.00	$ 1,234,000.00	$ 12,340,000.00	$ (123.40)	$ (1,234.00)	Accounting

Cell 1
	Cell 2
		Cell 3
			Cell 4
				Cell 5
			Cell 6
		Cell 7
	Cell 8
Cell 9
	Cell 10
		Cell 11
			Cell 12
				Cell 13
Red Blue					Cell 14
						Cell 15
					Cell 16
				Cell 17
			Cell 18
		Cell 19
	Cell 20
Cell 21
	Cell 22
		Cell 23
			Cell 24
				Cell 25
					Cell 26
				Cell 27
			Cell 28
		Cell 29
	Cell 30
Cell 31
	Cell 32
		Cell 33
			Cell 34
				Cell 35
			Cell 36
		Cell 37
	Cell 38
Cell 39
	Cell 40


	Colors From Patterns Picker


Actual	Answer		Formula
1	1		1
2	2		A1+1
3	3		A2+1
4	4		A3+1
5	5		A4+1
1	1		A5-A4
6	6		A5*A4
2	2		A6/A4
Formula	Formula		General!D2

			Common Functions
15	15		SUM
6	6		MAX
1	1		MIN
8	8		COUNT
3	3		AVERAGE

TRUE			Boolean
FALSE

			Errors
#DIV/0!	#DIV/0!	A1/0	Divide by 0
#NAME?	#NAME?	AVG(A3:A7)	Unknown Function
#VALUE!	#VALUE!	A5-A2	Bad Value
#NULL!	#NULL!	(SUM(A1:A10 C1:C10))	Bad Intersection
#REF!	#REF!	A3+A13	Bad Reference
#N/A	#N/A	VLOOKUP(0.1,range,2,TRUE)	Not Applicable
#NUM!	#NUM!	RATE(0, -200, 8000)	Problem with a Number

			Special Html Characters
	<		Less Than
	>		Greater Than
	&		Ampersand
	"		Quote
	…		Elipse

Bold	Italics	Underlined		Modifier
Left	Centered	Right		Justification
Arial	Times New Roman	Courier New		Fonts 12 Pts
Comic Sans	Brush Script	Verdana		Fonts 12 Pts


Font Sizing
8 Pts
10 Pts
12 Pts
14 Pts
18 Pts
24 Pts		^Superscript
36 Pts		_Subscript
48 Pts

Regular Bold Itallics Underlined

Chart Bar Chart

Last Updated on 12/3/01
By Steven Grubb