Skip to Content
Special Edition Using® Microsoft® Office 2003
book

Special Edition Using® Microsoft® Office 2003

by Ed Bott, Woody Leonhard
September 2003
Beginner to intermediate content levelBeginner to intermediate
1368 pages
56h 14m
English
Que
Content preview from Special Edition Using® Microsoft® Office 2003
701
Designing and Formatting a Worksheet for Maximum Readability
The results of this format can be absurd if you enter a number that’s smaller than 7 digits or
larger than 10 digits. Here’s how to use conditions to customize this format. The example
shown here assumes you work in the 212 area code and want to add that code to the begin-
ning of any 7-digit (local) number; if the number uses more than 10 digits, the default con-
dition at the end kicks in, adding the international dialing prefix (+011) and splitting the
digits before the number into country and city codes.
[<=9999999](212) ###-####;[<=9999999999](###) ###-####;”+011 “(#-##) ###-#### ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Special Edition Using Microsoft® Office XP

Special Edition Using Microsoft® Office XP

Ed Bott, Woody Leonhard
Special Edition Using Microsoft® PowerPoint® 2002

Special Edition Using Microsoft® PowerPoint® 2002

Patrice-Anne Rutledge, Tom Mucciolo

Publisher Resources

ISBN: 0789729555Purchase Link