Microsoft Y2K  
Microsoft
 This static CD-based web site is representative of the year2000.msn.ca site as of October 13, 1999.

 
Y2K home   Y2K site map
  Introduction
  ò  What is the Year 2000 Challenge?
  ò  Should I Care?
  ò  What Can I Do?
  Exploring Your PC
  ò  Three Parts of Your PC
  ò  Hardware
  ò  Software
  ò  Personal Files
  Taking Action
  ò  Action Steps
  ò  Hardware
  ò  Software
  ò  Personal Files
  ò  Action Summary
  Learning More
  ò  Quick Tips
 page pointer  FAQ
  ò  Glossary
  ò  Microsoft Product Analyzer
  ò  Microsoft Product Information
  ò  Microsoft Links
  ò  General Year 2000 Reading Links
Year 2000 Readiness Disclosure. A special feature brought to you by Microsoft Frequently Asked Questions

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.

backFAQ main page previous question27 | 29next question

Additional Terms of Use

go to msn.ca⌐ 1999 Microsoft Corporation. All rights reserved. Terms of use. Privacy Policy