XL: Year 2000 Wizards for Microsoft Excel 97 and 2000 Available for Download

ID: Q176943

The information in this article applies to:

Microsoft Excel 97 for Windows
Microsoft Excel 2000

SUMMARY

Microsoft has developed four date migration add-in tools that you can use with Microsoft Excel 97 and Microsoft Excel 2000. These can help you prepare dates in Excel workbooks for transitioning from earlier versions of Excel or for auditing workbooks for the year 2000.

The Date Fix Wizard allows you to change the date format of two-digit-year dates quickly and easily, or to modify serial number dates so that they fall within a specified century.

The Date Function Wizard searches for workbooks that contain the Date function. The Date function does not handle two-digit shortcuts.

The Date Migration Wizard handles specific kinds of dates that are in workbooks created in earlier versions of Excel. These dates use years that are two-digit numbers between 20 and 29.

The Date Watch Wizard monitors your work for year-ambiguous dates and formats.

MORE INFORMATION

Installation and Use

To install the Date Migration Tools, download the following file from the Microsoft Software Library

Xldate.exe

which contains the four wizards mentioned here.

Release Date: May-17-1999

For more information about how to download files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:

Q119591 How to Obtain Microsoft Support Files from Online Services

After you download the Xldate.exe file, double-click it to extract the four wizard files. By default, these files will be installed in the following folder:

C:\Program Files\Microsoft Office\Office\Library

To use the Date Migration tools, start Excel, and then click Add-Ins on the Tools menu. Click to select one of the following add-ins and then click OK:

Date Fix Wizard
Date() Function Wizard for Windows
Date Migration Wizard for Windows
Date Watch

NOTE: Microsoft recommends that you run only one add-in a time. Do not have more than one of these wizards selected at a time in the Add-Ins dialog box.

Additional query words: XL97 2019 2020 2029 2030 1919 1920 1929 1930 2000 year Date Migration Dates Y2K year2000


Keywords          : kbfile kbdta xladdins 
Version           : WINDOWS:2000,97
Platform          : WINDOWS 
Issue type        : kbinfo

Last Reviewed: July 31, 1999