Excel: Lotus 1-2-3 ISNUMBER Function Changes to ISNONTEXT

ID: Q95195


The information in this article applies to:
  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0


SUMMARY

When you open a Lotus 1-2-3 worksheet in Microsoft Excel, the Lotus 1-2-3 ISNUMBER function will change to ISNONTEXT().

When you save a Microsoft Excel document in Lotus 1-2-3 format, both the ISNUMBER and the ISNONTEXT() functions will be changed to ISNUMBER.


MORE INFORMATION

This behavior occurs because the Lotus 1-2-3 ISNUMBER function is different from the Microsoft Excel ISNUMBER() function--the Microsoft Excel ISNONTEXT() function is equivalent to the Lotus 1-2-3 ISNUMBER function.

The Lotus ISNUMBER function will return TRUE if the argument in that function is a value, an error, or is blank. This function will only return FALSE if the argument is text or a label. This behavior is equivalent to the behavior of the Microsoft Excel ISNONTEXT() function.

The Microsoft Excel ISNUMBER() function will only return true if the argument is a number. If the number is an error or blank the function will return FALSE. There is no equivalent for this function in Lotus 1-2-3.

If you save a Microsoft Excel sheet containing the ISNUMBER() function in WKS format, the following error message will appear

Cannot write record (Cell: <cell reference>)
where <cell reference> is the cell containing the ISNUMBER() function. This error message indicates that Microsoft Excel cannot find a Lotus equivalent for ISNUMBER(). In this case the function will be saved as the value 0 or 1.

If the Microsoft Excel sheet is saved in WK1 or WK3 format, both ISNUMBER() and ISNONTEXT() will change to ISNUMBER.


REFERENCES

"User's Guide," version 5.0, chapter 3
"Lotus 1-2-3 for Windows User's Guide," version 1.0, page 103
"Microsoft Excel Function Reference," version 4.0, page 248

Additional query words: 4.0 4.0a 4.00a 5.0

Keywords :
Version : 2.X 3.00 4.00 5.00
Platform : WINDOWS
Issue type :


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