Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
XL 2003, True, False, 1, 0
Hi,
I am using XL 2003 and whenever I enter TRUE or FALSE into a spreadsheet cell, it immediately turns to 1 or 0. I made sure that the number format is general. And I created a "boolean" style, again putting the number format to general. But I still get only 1 or 0 displayed in the cell, even though the formula bar entry shows TRUE or FALSE. How do I get the spreadsheet to display TRUE or FALSE? I inherited this spreadsheet, so I am not sure what setting caused this to happen. Best regards, Kevin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
XL 2003, True, False, 1, 0
Tools Options Transition Transition formula evaluation may be checked. Caution: If transition formula evaluation is checked, there may be formulas in your spreadsheet that require it in order to calculate correctly. -- CaptainQuattro ------------------------------------------------------------------------ CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763 View this thread: http://www.excelforum.com/showthread...hreadid=545722 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
XL 2003, True, False, 1, 0
Captain,
Nope, it ain't checked. Everything is blank. Other ideas? Tools Options Transition Transition formula evaluation may be checked. Caution: If transition formula evaluation is checked, there may be formulas in your spreadsheet that require it in order to calculate correctly. -- CaptainQuattro |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
XL 2003, True, False, 1, 0
It can be either of these 3 IMHO,
transition formula evaluation undertoolsoptiontransition (most likely, check again) Autocorrect (not very likely) Event macro (not very likely) -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Harry Sampson" wrote in message ... Captain, Nope, it ain't checked. Everything is blank. Other ideas? Tools Options Transition Transition formula evaluation may be checked. Caution: If transition formula evaluation is checked, there may be formulas in your spreadsheet that require it in order to calculate correctly. -- CaptainQuattro |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
XL 2003, True, False, 1, 0
Hi,
Hmm... This is a tough one. Tools Options Transition Save Excel files as Microsoft Office Excel Workbook Microsoft Office Excel menu key: / No check Transition navigation keys No check Transition formula evaluation No check Transition formula entry So I can rule that one out. On this workbook, there are three worksheets. I discovered on the first worksheet, that "True" and "false" do show up correctly in the cells. On the third worksheet, TRUE and FALSE automatically evaluate to 1 or 0, even though the formula bar shows TRUE and FALSE. There are no macros and I don't think autocorrect would work because then the above statement wouldn't hold true about formula bar and cell display. I tried copying "TRUE" from worksheet one to worksheet three. I copy *everything* (formula and format). It still shows 1 in the cell. So I am puzzled. I would like the cell display to show "TRUE". Peo Sjoblom wrote... It can be either of these 3 IMHO, transition formula evaluation undertoolsoptiontransition (most likely, check again) Autocorrect (not very likely) Event macro (not very likely) -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
XL 2003, True, False, 1, 0
Something you may want to try: Before attempting the following make a backup of you file and move it somewhere safe. Insert a new worksheet Copy the entire "broken" worksheet to the clipboard Paste Special Formulas to Cell A1 of the new worksheet. If TRUE and FALSE work correctly on the new worksheet, copy and "Paste special" the formats and column widths from the broken worksheet to the new version. Next, you will need to use Edit Replace (Or Ctrl-H) to Find all references to the broken page on each of the other 2 worksheets, and replace them with references to the new page. Finally, you can delete the broken page and bestow its name on the new version. -- CaptainQuattro ------------------------------------------------------------------------ CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763 View this thread: http://www.excelforum.com/showthread...hreadid=545722 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
XL 2003, True, False, 1, 0
But did you go to the 3rd worksheet when you checked it? These settings are
at the sheet level so that if sheet 1 is active you won't see anything but if you change to sheet 3 it will be checked? Peo "Harry Sampson" wrote: Hi, Hmm... This is a tough one. Tools Options Transition Save Excel files as Microsoft Office Excel Workbook Microsoft Office Excel menu key: / No check Transition navigation keys No check Transition formula evaluation No check Transition formula entry So I can rule that one out. On this workbook, there are three worksheets. I discovered on the first worksheet, that "True" and "false" do show up correctly in the cells. On the third worksheet, TRUE and FALSE automatically evaluate to 1 or 0, even though the formula bar shows TRUE and FALSE. There are no macros and I don't think autocorrect would work because then the above statement wouldn't hold true about formula bar and cell display. I tried copying "TRUE" from worksheet one to worksheet three. I copy *everything* (formula and format). It still shows 1 in the cell. So I am puzzled. I would like the cell display to show "TRUE". Peo Sjoblom wrote... It can be either of these 3 IMHO, transition formula evaluation undertoolsoptiontransition (most likely, check again) Autocorrect (not very likely) Event macro (not very likely) -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
XL 2003, True, False, 1, 0
Hi,
Yes, I think there was some corruption. I modified your approach by using a new workbook and copying all the sheets using the steps you provided. And then I had to adjust the links. Thanks. "CaptainQuattro" <CaptainQuattro.28egka_1148621700.8263@excelforu m-nospam.com wrote in message news:CaptainQuattro.28egka_1148621700.8263@excelfo rum-nospam.com... Something you may want to try: Before attempting the following make a backup of you file and move it somewhere safe. Insert a new worksheet Copy the entire "broken" worksheet to the clipboard Paste Special Formulas to Cell A1 of the new worksheet. If TRUE and FALSE work correctly on the new worksheet, copy and "Paste special" the formats and column widths from the broken worksheet to the new version. Next, you will need to use Edit Replace (Or Ctrl-H) to Find all references to the broken page on each of the other 2 worksheets, and replace them with references to the new page. Finally, you can delete the broken page and bestow its name on the new version. -- CaptainQuattro ------------------------------------------------------------------------ CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763 View this thread: http://www.excelforum.com/showthread...hreadid=545722 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
XL 2003, True, False, 1, 0
Peo, good work. Yes, it is sheet specific. When I went to sheet 3, I noted
the check mark. Although I thought I had checked before. Obviously not. In any event, I recreated the workbook, so the problem has been solved, albeit using more force than necessary. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing Rows for Printing | Excel Worksheet Functions | |||
Inconsistent Macro Behavior | Excel Discussion (Misc queries) | |||
Help: runtime error - Method seriescollection object_chart failed | Charts and Charting in Excel | |||
Hiding cells on condition | Excel Worksheet Functions | |||
update row numbers after different active cells in macros followi. | Excel Discussion (Misc queries) |