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

• Microsoft Excel 97 for Windows
• Microsoft Excel 2000

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://officeupdate.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:

  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/

• 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

DM2.exe

http://www.microsoft.com/downloads/search.asp

C:\Program Files\DMW

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

http://officeupdate.microsoft.com/2000/articles/ExY2K20Tools1.htm

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

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