Works: Errors Importing Information from Microsoft Profit (115870)


The information in this article applies to:

  • Microsoft Works 2.0
  • Microsoft Works 2.0a
  • Microsoft Works 3.0
  • Microsoft Works 3.0a
  • Microsoft Works 3.0b
  • Microsoft Works 4.5
  • Microsoft Works 4.5a
  • Microsoft Works for Windows 95, version 4.0
  • Microsoft Works for Windows 95, version 4.0 4.0a
This article was previously published under Q115870

SYMPTOMS

When importing information (reports) from Microsoft Profit into Works version 2.0 or 3.0, certain cells in the Database or Spreadsheet module may return a value of number signs (#####), where the format of the cell is set to Date. In Works version 4.0, 4.5 or 4.5a, "Invalid Date" (without the quotation marks) will be displayed in the cells. Widening the cell's width will not correct the problem.

This can occur because Microsoft Profit puts a zero (0) into cells when the cells are left blank. The value of zero, or any number less than one, is not a valid Works date value, and Works will fill the cell with number signs or with "Invalid Date."

RESOLUTION

Do one of the following:

  • Replace the zeros with valid dates in Works.

    -or-

  • Delete the zeros in Works.

MORE INFORMATION

To import the file from Microsoft Profit into Works, export the reports in Profit as a delimited ASCII text file. You can then open the file in Works as a Database or Spreadsheet file.

If Works is on the same system as the Profit program, you can select "View RPT In Microsoft Works For Windows" from the View menu.

One way to see this behavior is through the following example:

  1. Create a new spreadsheet in Works.
  2. In cell A1, type May and press ENTER.

    NOTE: This will cause the cell to be formatted as a date.
  3. In cell A1, type the number zero (0) and press ENTER.
Cell A1 will now display this behavior.
Modification Type:MajorLast Reviewed:11/15/2004
Keywords:kbprb KB115870
©2004 Microsoft Corporation. All rights reserved.