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

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)
 
H

Harlan Grove

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting TRUE/FALSE to 1/0 11
Formatting TRUE as 1 and FALSE as 0 2
Boolean 0/1 instead of True/False 10
XL 2003, True, False, 1, 0 8
Display TRUE / FALSE Instead Of 1 / 0 11
Conditional Formatting with Calculated Blank 2
Converting TRUE/FALSE from AND to number, like 1 or 0 4
format logical values 2

Top