## XL5: Formula in WK4 File Displays #VALUE! Error Value

The information in this article applies to:

- Microsoft Excel for Windows, versions 5.0, 5.0c

## SYMPTOMS

In Microsoft Excel, when you open a Lotus 1-2-3 WK4 file, a cell on the worksheet may display the #VALUE! error value even though the formula contained in the cell is displayed correctly in the formula bar.

## CAUSE

This behavior occurs when the formula is converted properly (displays the correct formula in the formula bar), but initially evaluates to the #VALUE! error value. For example, if your Lotus 1-2-3 WK4 file contains the following formula

       @@(A1:A1)

where A1 contains the formula @@COORD(1,2,1,8)&" "&@@COORD(1,2,1,8) and cell A2 is blank, the cell that contains the formula displays the #VALUE! error value when you open the file in Microsoft Excel.

## WORKAROUND

To display the correct value in a cell that displays the #VALUE! error value under the above conditions, use the appropriate method for your situation.
Method 1: To display the value in an individual cell, follow these steps:

1. Select the cell that contains the formula that is displaying the #VALUE! error value.
2. Press F2.
3. Press ENTER.

Method 2: To display the value in multiple cells, follow these steps:

1. Select the worksheet that contains the #VALUE! Error values.
2. From the Edit menu, choose Replace.
3. In the Find What box, type =. In the Replace With box, type =, and choose Replace All.

## MORE INFORMATION

To open Lotus 1-2-3 WK4 files in Microsoft Excel, you must obtain the Lotus 1-2-3 WK4 File Converter. The Lotus 1-2-3 WK4 File Converter is available in application note WE1130 "Lotus 1-2-3 WK4 File Converter."
For more information about obtaining the Lotus 1-2-3 WK4 File Converter, please see the following article in the Microsoft Knowledge Base:

> Q122583 XL5: Lotus 1-2-3 Release 4 for Windows File Converter

Lotus 1-2-3 is manufactured by Lotus Corporation, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

## REFERENCES

Lotus 1-2-3 WK4 File Converter README.TXT

Additional query words:

Keywords :
Version : WINDOWS:5.0,5.0c
Platform : WINDOWS
Issue type :
Technology :

Last Reviewed: September 20, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use.