Microsoft KB Archive/240929

= Works 3.0: How to Use the Works 3.0 File Updater =

Article ID: 240929

Article Last Modified on 7/6/2007

-

APPLIES TO


 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 3.0b

-



This article was previously published under Q240929



SUMMARY
This article describes how to work around a year 2000 issue that you may experience when you run Microsoft Works for Windows versions 3.x.



MORE INFORMATION
In Works, you can format dates in spreadsheet cells and database fields to display dates in two-digit or four-digit years.

When you format a date cell or field to display a two-digit year, Works automatically assigns the "19" prefix to the year the next time you edit that cell or field. If you enter a four-digit year in a date cell or field formatted to display a two-digit year, Works automatically assigns the "19" prefix to the year. When you enter a date in a date cell or field without entering the year, Works automatically assigns the "19" prefix followed by the last two digits of the current year to that date.

In these cases, a date cell or field in the year 2000 becomes the year 1900. But this error is difficult to detect if that date cell or field is formatted to display only a two-digit year and the "19" prefix is not visible.

To work around this issue, use both of the following methods.

Format Date Cells and Fields in New Spreadsheets and Databases with Four-Digit Years
Whenever you create a new spreadsheet and database in Works, make sure that you format date cells and fields to display four-digit years.

Use the Works 3.0 File Updater
Download and run the Works 3.0 File Updater to check your Works spreadsheet and database files for any date cells and fields formatted to display two-digit years. The Works 3.0 File Updater automatically converts the year in all of those cells and fields to a four-digit year format, enabling you to see any potential errors. You can then manually change any years that are incorrect.

NOTE: No year 2000 software updates are planned for Works 3.0 or earlier.

How to Run the Works 3.0 File Updater
To download the Works 3.0 File Updater, use the appropriate method for your version of Microsoft Windows.

Microsoft Windows 95 and Microsoft Windows 98:  Click Start, and then click Run. In the Open box, type the following line, and then click OK

 :\Wks3updt.exe

where  is the drive letter of the hard disk on which the Works 3.0 File Updater is installed. When the End-User License Agreement appears, click I Accept. Click No. Follow the instructions on the screen until you are prompted to make sure that your system date displays the year in the four-digit format. To do this:

 Click Start, point to Settings, and then click Control Panel. Double-click Regional Settings.</li> Click the Date tab.</li> Under Short Date, click to select the date format that contains a four-digit year, such as, "M/d/yyyy."</li> Click OK.</li> Close Control Panel.</li></ol> </li> In the Update Files In box in the Works 3.0 File Updater, type the folder location of the Works 3.0 spreadsheet and database files that you want to update.</li> Click Start.</li> When the update is finished, click View Report to see the changes that have been made.</li></ol>

Microsoft Windows 3.1: <ol> On the Window menu, click Main.</li> Double-click File Manager.</li> On the File menu, click Run.</li> In the Command Line box, type the following line, and then press ENTER

 :Wks3updt.exe

where  is the drive letter of the hard disk on which the Works 3.0 File Updater is installed.</li> When the End-User License Agreement is displayed, click I Accept.</li> Click No.</li> Follow the instructions on the screen until you are prompted to make sure that your system date displays the year in the four-digit format. To do this:

<ol style="list-style-type: lower-alpha;"> On the Window menu, click Main.</li> <li>Double-click the Control Panel icon.</li> <li>In the Control Panel window, double-click the International icon.</li> <li>Under Date Format, click Change.</li> <li>Under Short Date Format, make sure that the Century check box is selected.</li> <li>Click OK.</li> <li>Close Control Panel.</li></ol> </li> <li>In the Update Files In box in the Works 3.0 File Updater, type the folder location of the Works 3.0 spreadsheet and database files that you want to update.</li> <li>Click Start.</li> <li>When the update is finished, click View Report to see the changes that have been made.</li></ol>

<div class="references_section">