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


The information in this article applies to:

  • Microsoft Works 6
  • Microsoft Works Suite 2001
  • Microsoft Works 7.0
  • Microsoft Works Suite 2002
  • Microsoft Works Suite 2003
This article was previously published under Q265908

SYMPTOMS

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.

CAUSE

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

=NOW()

RESOLUTION

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.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:9/18/2003
Keywords:kbbug kbconversion kbinterop kbpending KB265908
©2003 Microsoft Corporation. All rights reserved.