Excel 2000 - 32-Bit Windows Recommendation: Set the short date format in Windows Control Panel to display four-digit years. See Knowledge Base Article "Year 2000 Wizards for Microsoft Excel 97 and 2000" for information on date wizards designed to help you prepare dates in Excel for the year 2000. Date handling: Excel 2000 by default displays two digits (yy) for the year and interprets two-digit shortcuts for years 00 - 29 to be 2000 - 2029 and 30 - 99 to be 1930 - 1999. However, the time period can be changed in Windows 98, and in the current plans for Windows 2000, by changing the setting on the Date tab in Regional Settings in Control Panel. For more information: See the Excel 2000 Product Guide document.

Excel (Macintosh) 98 Recommendation: Install Office 97 Service Release 2. To request the update on CD-ROM call 888-673-8925 toll free. Set the short date format in Windows Control Panel to display four-digit years. See Knowledge Base article "Year 2000 Wizards for Microsoft Excel 98" for information on date wizards designed to help you prepare dates in Excel for the year 2000. Date handling: Excel 97 by default displays two digits (yy) for the year. When two-digit shortcuts are entered for years, 00 - 29 is interpreted to be 2000 - 2029 and 30 - 99 is interpreted to be 1930 - 1999. For more information: See the Excel (Macintosh) 98 Product Guide document and Knowledge Base articles "How Microsoft Excel Works with Two-Digit Year Numbers" and "Dates Inserted by Recorded Macro May Be in Wrong Century".

Excel 97 - 32-Bit Windows Recommendation: Install Office 97 Service Release 2. To request the update on CD-ROM call 888-673-8925 toll free. Set the short date format in Windows Control Panel to display four-digit years. See Knowledge Base article "Year 2000 Wizards for Microsoft Excel 97 and 2000" for information on date wizards designed to help you prepare dates in Excel for the year 2000. Date handling: Excel 97 by default displays two digits (yy) for the year. When two-digit shortcuts are entered for years, 00 - 29 is interpreted to be 2000 - 2029 and 30 - 99 is interpreted to be 1930 - 1999. For more information: See the Excel 97 Product Guide document and Knowledge Base articles "How Microsoft Excel Works with Two-Digit Year Numbers", "Dates Inserted by Recorded Macro May Be in Wrong Century" and "Wrong Date Returned When You Enter Month and Digits".

Excel 95 - 32-Bit Windows Recommendation: Install the Office 95 Year 2000 Update. To request the update on CD-ROM call 888-673-8925 toll free. Set the short date format in Windows Control Panel to display four-digit years. Date handling: When two-digit shortcuts are entered, 00 - 19 is interpreted to be 2000 - 2019 and 20 - 99 is interpreted to be 1920 - 1999. For more information: See the Excel 95 Product Guide document and Knowledge Base article "How Microsoft Excel Works with Two-Digit Year Numbers".

top	back to product info
Additional Terms of Use
Page 1 of 2