Microsoft KB Archive/265908

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

Article ID: 265908

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Works 6.0
 * 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.
 * 1) On the Format menu, click Number.
 * 2) 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.

Additional query words: works6 w_works

Keywords: kbbug kbconversion kbinterop kbpending KB265908

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.