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 |
