TRUE and FALSE have a special meaning in Excel. That's why Excel does what
it does!

One way to do this:

Try adding these to your AutoCorrect library:

ToolsAutoCorrect options
Replace: false
With: 'false

Do the same with true.

Note that this will apply to all Office programs, not just Excel. So, if you
open a Word document and type in false it will change to 'false. The
apostrophe won't be displayed in Excel but it will in Word. You might just
want to "live with it" the way it is!

--
Biff
Microsoft Excel MVP


"drs207" wrote in message
...
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.