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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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)
Click to expand...

Not formatting.

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