419197041.
xls
Custom Format Cell Entry
Using text
#,##0 "US Dollars" 1500
"Answer: "General 1500
"The amount is "#,##0" dollars" 1500
Scaling
large
numbers
#,##0, 123456789
#,##0, 12345678912
#,##0, 1234
Data
Validation
0.00;"Positive numbers only!" 123
0.00;"Positive numbers only!" -123
0.00;"Positive numbers only!" 0
Zero with
Dashes
#,##0_);(#,##0);-0-_) 0
#,##0_);(#,##0);-0-_) 12.2
#,##0_);(#,##0);-0-_) -12
Telephone
Numbers
(###) ###-### 8005551212
###"/"###-#### 8005551212
Social
Security
Numbers
###-##-#### 421897322
SSN ###-##-#### 421897322
Date
Formats
mmmm-yy 6/1/1995
mmmm d, yyyy 6/1/1995
dddd 6/1/1995
mmmm d, yyyy (dddd) 6/1/1995
"It's" dddd 6/1/1995
Different
colors and
formatting
[Red][<1]0.0%;[Blue][>=1]#,##0;Genera 1
[Red][<1]0.0%;[Blue][>=1]#,##0;Genera -1
[Red][<1]0.0%;[Blue][>=1]#,##0;Genera 45
General;General;General;[Red]General Only text is red
Page 1
419197041.xls
General;General;General;[Red]General 234
Special
symbols
©General 1994
General;General;General;General® Registered
General;General;General;General™ Coca-Cola
General;General;General;“General” Text in quotes
General;General;General;“General” 123
Descriptive Positive;"Negative";"Zero";"Text" 12
Positive;"Negative";"Zero";"Text" -32
Positive;"Negative";"Zero";"Text" 0
Positive;"Negative";"Zero";"Text" Hello
Hidden ;;; 1234
;;; -145
Conditional
[>100]#,000;;; 99
[>100]#,000;;; 102
[>100]#,000;;; -54
[>100]#,000;;; Hello
Page 2
419197041.xls
How it Appears
1,500 US Dollars
Answer: 1500
The amount is 1,500 dollars
123,457
12,345,679
1
123.00
Positive numbers only!
0.00
-0-
12
(12)
(800) 555-1212
800/555-1212
421-89-7322
SSN 421-89-7322
June-95
June 1, 1995
Thursday
June 1, 1995 (Thursday)
It's Thursday
1
-100.0%
45
Only text is red
Page 3
419197041.xls
234
©1994
Registered®
Coca-Cola™
“Text in quotes”
123
Positive
Negative
Zero
Text
102
Page 4
