Logical Format showing 0/1 and not True/False.
 

Following my previous question regarding boolian calculations. I now have an
old worksheet which has been upgraded over the years from "other" packages.
Results to logical expressions are shown as 0 and 1 as opposed to True and
False in the worksheet. How can I correct this formatting. (I assume it is
formatting)

Logical Format showing 0/1 and not True/False.
 

Tony wrote...
Following my previous question regarding boolian calculations. I now have an
old worksheet which has been upgraded over the years from "other" packages.
Results to logical expressions are shown as 0 and 1 as opposed to True and
False in the worksheet. How can I correct this formatting. (I assume it is
formatting)

Not formatting.

Tools Options, select Transition tab, uncheck Transition formula
evaluation, click OK.

Logical Format showing 0/1 and not True/False.
 

Thanks. Perfect answer

"Tony" wrote:

Following my previous question regarding boolian calculations. I now have an
old worksheet which has been upgraded over the years from "other" packages.
Results to logical expressions are shown as 0 and 1 as opposed to True and
False in the worksheet. How can I correct this formatting. (I assume it is
formatting)