Disable autoformat of "true" and "false" text

[drs207]

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.

 

[John C]

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.

 

[Wigi]

No, there isn't.

 

[Mike H]

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

 

[Rick Rothstein \(MVP - VB\)]

Try formatting the cell(s) or column (whichever applies to your situation)
as Text first.

Rick

 

[T. Valko]

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:

Tools>AutoCorrect 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!