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
695
Changing Formatting for a Cell or Range
Because Excel stores dates as serial values, it is unaffected by most garden-variety Y2K prob-
lems. In practice, however, you might encounter Y2K problems if you enter or import data
that includes only two digits for the year. When Excel encounters dates in this format, it has
to convert the year to four digits; in the process, it’s possible to select the wrong century.
When translating two-digit years, Excel uses the following rules:
Excel automatically converts dates entered using the two-digit years 00 through 29 to
the years 2000 through 2029. Thus, if you enter or import the value
5/23/04, Excel
stores ...
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