Boolean expressions

[Guest]

How do I change the windows default from true/false to 1/0 (for boolean expressions)

I do realize that I can multiply the result by 1, but there has to be a setting that I can change.

 

[Frank Kabel]

Hi Brad
AFAIK there is no setting. You may use a custom format to display 1/0
but in all other cases simply convert the boolean expression by
multiplying with one or
=--boolean_expression

 

[Bernard Liengme]

I hate to contradict Frank but if you use Tools|Options and open the
Transitions tab you will see a box labelled Transition Formula Evaluation.
Check this and for your current sheet you will get 1 and 0 in place of TRUE
and FALSE.

Has to be done to all sheets in a workbook (I think you could group them and
do it once - try it)

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address

How do I change the windows default from true/false to 1/0 (for boolean expressions)?

I do realize that I can multiply the result by 1, but there has to be a

setting that I can change.

 

[Frank Kabel]

Hi Bernard
But he will change a lot more things with this option
Though I had to admit I've never used this option

 

[Guest]

Thanks

That work. However, what else does this change?

 

[Dave Peterson]

One thing that I find difficult to track down:

In A1: ASDF
in B1: =if(a1=0,1,2)

Then toggle that setting and watch B1.

Lotus 123 treats text differently than excel.

(This is scary enough for me to stay away from that setting!)