Works: Date and Time Are Not Copied from Database to Spreadsheet

When you create a Microsoft Works Database file that contains date and time values, and then try to copy and paste this data to a Works Spreadsheet file, the date and time values may not appear in the Works Spreadsheet file.

This problem may occur if the date and time are created with the following formula:

To work around this problem, copy data with date and time values from Works Database to Works Spreadsheet cell by cell, and then change the cell formatting as required. To do so, follow these steps:

1. In Works Database, select Row 1, Field 2.
2. On the Edit menu, click Copy.
3. Switch to Works Spreadsheet.
4. Select cell B1.
5. On the Edit menu, click Paste.
6. Switch to Works Database.
7. Select Row 1, Field 3.
8. On the Edit menu, click Copy.
9. Switch to Works Spreadsheet.
10. Select cell C1.
11. On the Edit menu, click Paste.
    
    A time serial number appears.
12. On the Format menu, click Number.
13. On the Number tab, click Time, and then click OK.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.