hi,

No other way that I'm aware of. These are operators used by Excel in Boolean
evaluation and I think your stuck with the workarounds you mention.

Mike

"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.