software

Hi All,

I have a workbook, which automatically formats TRUE as 1 and FALSE 0.
That is, if I enter a formula quot;=TRUEquot; 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: www.excelforum.com/member.php...oamp;userid=33173
View this thread: www.excelforum.com/showthread...hreadid=529949You have Transition formula entry set.

Go to Toolsgt;Optionsgt;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)

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

Got it Thanks a lot--
reddykkk
------------------------------------------------------------------------
reddykkk's Profile: www.excelforum.com/member.php...oamp;userid=33173
View this thread: www.excelforum.com/showthread...hreadid=529949