

This static CD-based web site is representative of the www.microsoft.com/y2k site as of September 15th, 1999.

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

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.

NOTE: Because the Date Watch Wizard is a macro, it disables the Undo feature of Excel when triggered.

NOTES

These wizards are designed for Microsoft Excel 97 and Microsoft Excel 2000 products only. If you have Microsoft Excel 98 Macintosh Edition, please click the article number below to view the article in the Microsoft Knowledge Base:
Q193344 XL98: Year 2000 Wizards for Microsoft Excel 98
If you have a different version, then for more information about how other Microsoft products are affected by year 2000 (Y2K) issues, please see the following Microsoft World Wide Web site:
http://www.microsoft.com/year2000/
This article points to the latest versions of these wizards, which replace any earlier versions. If you have previously downloaded these wizards, you may want to make sure you have the latest version.

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 XL2000 2019 2020 2029 2030 1919 1920 1929 1930 2000 year Date Migration Dates Y2K year2000

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