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.