Custom Number Formats

1)	Ctrl + 1 is the keyboard shortcut for the Format Cells Dialog Box
2)	The Number Tab has many EXCELlent number formats
3)	The Custom section let's you create custom Number Formatting
4)	Before the 1st semi-colon is how to display positive numbers
5)	Before the 2nd semi-colon and after the 1st semi-colon is how to display negative numbers
6)	Before the 3rd semi-colon and after the 2nd semi-colon is how to display zeros
7)	After the 3rd semi-colon is whether or not and how to display text
8)	If you just have formatting symbols before the 1st semi-colon, the formatting will apply to positive, negative and zero numbers and text will display
9)	When General Number Format is applied, all Custom Number Formatting will be removed
10)	The TEXT function converts a number to text with a Custom Number Format that you specify. TEXT(number, "Custom Number Format in quotes")
Symbol	Usage	Typed digits	Displayed value
#	Digit placeholder that displays significant digits only; example ####.#	12.77	12.8
		5	5.
0	Digit placeholder that displays significant and insignificant zeroes; example: 0.00	0.35	0.35
		23	23.00
0	Zeros before digit like 00345; example: 00000	345	00345
0	display many digits 0.000000000000000	.125489632586635	0.125489632586635
?	Acts as a digit placeholder that does not display insignificant digits but does hold a place so that decimal points will align; example: 0.00?	27.3	27.30
		5.132	5.132
?	Scoots the decimal over; example: 0.00????	27.3	27.30
		5.132	5.132
%	Rules for formatting a % (times 100 and add symbol); example 0.00%	.3	30.00%
,	Inserts a comma for thousands; example: #,###	1000000	1,000,000
,	Use as a scaling operator; example #,,	1000000	1
*	Tells the cell to put enough of the character (space) after it to fill the column; example $* 0.00	548	$                         548.00
*	Tells the cell to put enough of the character (^) after it to fill the column; example $*^0.01	548	$^^^^^^^^^^^548.01
_	Skip the width of the next character - often used with ) to help positive numbers align with negative numbers; example: _($* #,###0.00_);_($* (#,###0.00);_(* "-"??_);_(@_)	256.36	$                       256.36
_	example: _($* #,###0.00_);_($* (#,###0.00);_(* "-"??_);_(@_)	-256.36	$                     (256.36)
_	example: _($* #,###0.00_);_($* (#,###0.00);_(* "-"??_);_(@_)	0	-
" "	adds text; example: 0.00" Rad"	23	23.00 Rad
" "	"surplus";"deficit"	5	surplus
		-10	deficit
@	Indicates the location where text should be inserted in cells formatted with custom format; if the @ is not included in the code, the text will not be displayed; example: _($@_)	none	$none
@	Use formatting to hide words; example: 0.00;-0.00;"--";	none
@	How to put a single character in front of a word; example: _(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(^@_)	rad	^rad
@	This scoots the text over one width of a parenthesis; example: _($* #,###0.00_);_($* (#,###0.00);_(* "-"??_);_(@_)	rad	rad
d	day; example: dddd	31-12-06	Sunday
m	month; example: mmm.	31-12-06	Dec.
y	year; example: yy	31-12-06	06
d	day; example: d	31-12-06	31
m	month; example: m	31-12-06	12
y	year; example: yyyy	31-12-06	2006
hh:mm:ss AM/PM	Time	8:00 AM	08:00:00 AM
[h]:mm	Show time greater than 24 hours	2	48:00
Note 1==>	If you specify only two formats, the first is used for positive and zero
Note 2==>	If you specify only one formats, it is used for all numbers