XL2000: How Transition Formula Entry Affects Behavior in Excel

Article translations Article translations
Article ID: 213953 - View products that this article applies to.
This article was previously published under Q213953
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all


In Microsoft Excel 2000, when the Transition formula entry check box is selected, you are able to enter and evaluate formulas in a manner more consistent with the behavior of Lotus 1-2-3. You may open Lotus 1-2-3 files without losing or changing information.

Whenever a Lotus 1-2-3 file is opened in Excel, this check box is automatically selected.

More information

To turn on the Transition Formula Entry functionality, click Options on the Tools menu, and then click the Transition tab. Under Sheet Options, click to select the Transition formula entry check box.

When Transition formula entry is selected, Excel converts formulas entered with Lotus 1-2-3 release 2.2 syntax to Excel syntax, and makes names defined in Excel behave as defined names behave in Lotus 1-2-3.

In addition, if the Transition formula evaluation check box is selected, when 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.


Article ID: 213953 - Last Review: October 26, 2013 - Revision: 4.0
Applies to
  • Microsoft Excel 2000 Standard Edition
kbnosurvey kbarchive kbinfo KB213953

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com