Formatting TRUE as 1 and FALSE as 0

[reddykkk]

Hi All,

I have a workbook, which automatically formats TRUE as 1 and FALSE 0. That is, if I enter a formula "=TRUE" in any cell, it results to 1. Where as in any other workbook, i get the result as TRUE.

I could not find any formatting or Macros doing this. How can I format workbooks to behave like this i.e. return 1 for TRUE and 0 for FALSE.

Thanks,
Kranthi

[Bob Phillips]

You have Transition formula entry set.

Go to Tools>Options>Transition tab and uncheck the transition formula
evaluation box at the foot of the tab.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"reddykkk" <[email protected]> wrote in
message news:[email protected]...
>
> Hi All,
>
> I have a workbook, which automatically formats TRUE as 1 and FALSE 0.
> That is, if I enter a formula "=TRUE" in any cell, it results to 1.
> Where as in any other workbook, i get the result as TRUE.
>
> I could not find any formatting or Macros doing this. How can I format
> workbooks to behave like this i.e. return 1 for TRUE and 0 for FALSE.
>
> Thanks,
> Kranthi
>
>
> --
> reddykkk
> ------------------------------------------------------------------------
> reddykkk's Profile:
http://www.excelforum.com/member.php...o&userid=33173
> View this thread: http://www.excelforum.com/showthread...hreadid=529949
>

[reddykkk]

Got it Thanks a lot