Microsoft KB Archive/176943

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

Article ID: 176943

Article Last Modified on 8/5/2004

-

APPLIES TO


 * 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.

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

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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.