You could format the cells you will be typing true or false into as text.
Turning off the TRUE/FALSE aspect of Excel I think in general is just a bad
idea, as that is the inherent use of Excel in the first place, to do 1 thing
if a condition is met, and something else if it isn't.
--
John C


"drs207" wrote:

Hi,

When I enter the words "true" or "false" by themselves in any excel cell (I
am using 2007 Pro), they are automatically centered and displayed in upper
case. When included in a sort (e.g., A-Z ascending) in this format, they
always appear at the bottom of the sort.

I am aware of some workarounds like preceding the text with an apostrophe as
in 'true or 'false or just adding an empty space right after it. But is there
a more direct way of simply turning off this feature? I can't seem to find
any when I go to excel options.

Thanks again for your valuable help.