The information in this article applies to:
SUMMARY
When you open a Lotus 1-2-3 worksheet in Microsoft Excel, the Lotus
1-2-3 ISNUMBER function will change to ISNONTEXT().
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.
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 Additional query words: 4.0 4.0a 4.00a 5.0
Keywords : |
Last Reviewed: March 30, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |