TechWeb Digital Library

How Excel Works With Two-Digit Year Numbers

Source: Microsoft
Date: January 2008
Type: White Paper
Rating: (0)

Overview: This paper published by Microsoft explains how Microsoft Excel determines the century. When one type a date using a two-digit year number (such as 98), Microsoft Excel uses specific rules to determine which century to use for the date. This paper discusses how Excel interprets three-part date entries that contain month, day, and year components. It is possible to enter a two-part date that contains only the day and month, or the month and year components of the date.


Click here to download now

View all content from this source

Not what you’re looking for? Search again
Go Advanced »
Email Alert

Receive an email alert whenever new content is added to the Windows/Microsoft section of the TechWeb Digital Library

More Windows/Microsoft Resources

Preventing Data Loss When Migrating to Microsoft 2007
Understand the data loss risks for businesses when migrating to Microsoft Exchange 2007. Learn the sources of these risks, the consequences of...

Lotus Notes and Microsoft Platforms: How you can Achieve Successful Coexistence and Interoperabilitys
Download this whitepaper to discover how you can achieve successful interoperability between Lotus Notes and Microsoft SharePoint and Exchange Server quickly.

Upcoming Webcasts

More On Windows/Microsoft