Disable autoformat of "true" and "false" text
 

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.

Answer: Disable autoformat of "true" and "false" text
 

Yes, there is a way to disable the autoformatting of "true" and "false" text in Excel. Here are the steps:

1. Click on the File tab in the top left corner of the Excel window.
2. Click on Options at the bottom of the left-hand menu.
3. In the Excel Options window, click on Proofing in the left-hand menu.
4. Click on the AutoCorrect Options button in the main window.
5. In the AutoCorrect window, click on the AutoCorrect tab.
6. In the "Replace text as you type" section, scroll down until you find "TRUE" and "FALSE" in the list.
7. Click on each one and then click the Delete button to remove them from the list.
8. Click "OK" to close the AutoCorrect window.
9. Click "OK" to close the Excel Options window.

That's it! Now Excel will no longer autoformat "true" and "false" text when you type them into a cell.

Disable autoformat of "true" and "false" text
 

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.

Disable autoformat of "true" and "false" text
 

No, there isn't.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


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

Disable autoformat of "true" and "false" text
 

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.

Disable autoformat of "true" and "false" text
 

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

Rick


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

Disable autoformat of "true" and "false" text
 

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.