| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
