Logical Test: Text Against Number

[rslaughter5]

Can anyone provide insight into how Excel treats this type of test? For
example, why does Excel return TRUE when we have ="a">2 but FALSE when ="a"<2
(or any other number for that matter).

Thanks.

 

[Max]

That's the way it is treated. Any kind of text is larger than the largest
number.
Any worth? hit the YES below

 

[RyGuy]

We went through this routine just a few days ago, on 12/31/2009.

http://www.microsoft.com/office/com...59eb3b7e6f0&cat=&lang=en&cr=US&sloc=en-us&p=1

Well, that was LAST year...