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

EMC Perspective: The Real-World Impact Of Microsoft Surface
EMC Consulting's interactive media capabilities is excited about Microsoft's newly launched Microsoft Surface device. Its early application in retail and entertainment spaces,...

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