R
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
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