How Transition Formula Entry Affects Behavior in MS Excel (141764)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
This article was previously published under Q141764 SUMMARY
When the Transition Formula Entry check box is selected, Microsoft
Excel allows you to enter and evaluate formulas in a manner more
consistent with the behavior of Lotus 1-2-3.
The Transition Formula Entry option allows you to open Lotus 1-2-3
files without losing or changing information. Note that whenever a
Lotus 1-2-3 file is opened in Microsoft Excel, these options are
automatically turned on.
MORE INFORMATION
To enable the Transition Formula Entry options, click Options on the
Tools menu, and then click the Transition tab. Under Sheet Options,
select the Transition Formula Entry check box.
When Transition Formula Entry is selected, Microsoft Excel converts
formulas entered with Lotus 1-2-3 release 2.2 syntax to Microsoft
Excel syntax and makes names defined in Microsoft Excel behave as
defined names behave in Lotus 1-2-3.
In addition, if the Transition Formula Evaluation check box is
selected, when Microsoft Excel evaluates formulas, text strings are
converted to 0, Boolean expressions are converted to 0 or 1, and
database criteria are converted according to the rules used in Lotus
1-2-3.
| Modification Type: | Minor | Last Reviewed: | 8/17/2005 |
|---|
| Keywords: | kbinfo kbualink97 KB141764 |
|---|
|