Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting TRUE as 1 and FALSE as 0
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting TRUE as 1 and FALSE as 0
You have Transition formula entry set.
Go to ToolsOptionsTransition 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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting TRUE as 1 and FALSE as 0
Got it :) Thanks a lot -- reddykkk ------------------------------------------------------------------------ reddykkk's Profile: http://www.excelforum.com/member.php...o&userid=33173 View this thread: http://www.excelforum.com/showthread...hreadid=529949 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shorten a Macro | Excel Discussion (Misc queries) | |||
Inconsistent Macro Behavior | Excel Discussion (Misc queries) | |||
Help: runtime error - Method seriescollection object_chart failed | Charts and Charting in Excel | |||
Grouped Sheets and Formating | Excel Discussion (Misc queries) | |||
Grand Totals @ Same Place | Excel Worksheet Functions |