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

Article ID: 176943

Article Last Modified on 8/5/2004

Microsoft Excel 2000 Standard Edition
Microsoft Excel 97 Standard Edition

This article was previously published under Q176943

SUMMARY

Microsoft has developed 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 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. Further, the Date Migration Wizard identifies potentially ambiguous date operations, uses of date functions and links to external databases that may introduce external date dependencies.
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. It also helps you look for dates with a format like "Dec 98", which will not function properly in the year 2001.

The Date Fix Wizard also identifies non-Gregorian formatted dates. International versions of Excel support the Hijri calendar, the Hebrew calendar, the Japanese Imperial calendar, and other calendar systems. Because these calendars are not approaching the year 2000, be careful about evaluating workbooks that contain dates using these non-Gregorian calendars.
The Date Watch Wizard monitors your work for year-ambiguous dates and formats, and corrects them when you type them into a cell.

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

NOTES

These Date Migration Tools are for Microsoft Excel 97 Service Release 2 (SR-2) and Microsoft Excel 2000 only. You must have SR-2 installed before you can install the Date Migration Tools. To obtain the SR-2 upgrade for Microsoft Excel 97 visit the following Web site:
http://office.microsoft.com
If you have Microsoft Excel 98 Macintosh Edition, please click the article number below to view the article in the Microsoft Knowledge Base:
193344 XL98: Year 2000 Wizards for Microsoft Excel 98
The Date Migration Tools are not compatible with XLM (Excel 4 Macro Language) programs. Please disable these before running the Date Migration Tools.
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.
In the past, the Date Migration Wizard did not locate or examine DATE, DAY, MONTH, NOW, and TODAY. The most recent version of the Date Migration Wizard does not locate or examine DAY, MONTH, NOW, or TODAY, but does locate and examine DATE. In the past, DATE checking was incorporated into the Date Function Wizard, but now DATE checking has moved to the Date Migration Wizard.

MORE INFORMATION

Installation and Use

To install the Date Migration Tools, download the following file from the Microsoft Download Center

[GRAPHIC: Download] Download DM2.exe now

which contains a single add-in file that includes the three wizards mentioned here. This is different from earlier versions of this tool that consisted of several add-in files. Although the number of wizards and add-in files has changed in this version, all functionality of the earlier versions has been maintained. Also, the tool now checks for date-sensitive functions used in defined names.

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

After you download the DM2.exe file, double-click it to install the wizard files. By default, these files are installed in the following folder:

C:\Program Files\DMW

After installation, several new menu commands appear in the Tools menu under Date Migration:

Date Watch
Date Fix Wizard
Date Migration Wizard
Next Date Function
Check Current Cell
Information from Last Cell Scanned
Stop Scan

For more information about how to use these tools, please see "How to Use Date Migration Tools 2.0 for Excel 97/2000" at the following Microsoft World Wide Web site:

http://office.microsoft.com/assistance/2000/ExY2K20Tools1.aspx

Additional query words: XL97 XL2000 2019 2020 2029 2030 1919 1920 1929 1930 2000 Y2K year2000 can't undo disabled gray grey dm2 exe

Keywords: kbinfo kbdownload kbgraphxlink kbfile KB176943