How Transition Formula Entry Affects Behavior in MS Excel

Article translations Article translations
Article ID: 141764 - View products that this article applies to.
This article was previously published under Q141764
Expand all | Collapse all


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.


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.


Article ID: 141764 - Last Review: August 17, 2005 - Revision: 1.3
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
kbinfo kbualink97 KB141764
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Give Feedback


Contact us for more help

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