28. What should I do about existing spreadsheets that have two-digit years?
If you plan to use these spreadsheets in the year 2000 and the spreadsheets contain information that is critical to you, it is best to adjust these files to contain four-digit years.
Microsoft has developed three date migration add-in tools for Microsoft Excel 97 to help customers adjust older spreadsheets and to monitor the creation of new ones. These free utilities are available at http://support.microsoft.com/support
/kb/articles/Q176/9/43.asp.
The Date Fix Wizard
Allows users to quickly find and change date formats of ambiguous two-digit-years or to modify dates so that they fall within a specified century.
The Date Migration Wizard
Helps ensure that two-digit-years are handled properly when worksheets created in an earlier version of Microsoft Excel are opened in Excel 97.
The Date Watch Wizard
Monitors your work for ambiguous and potentially risky dates and formats.
Additional Terms of Use |
