Weird string to int conversion

Sorry misread.


I could not duplicate problem.

I'"m no VBA man, but if you enter ="4830">4830 in a cell it yields TRUE because XL first evaluates the TYPE() function. ( before any other comparison)
TYPE(string) =2 and TYPE( number) =1
If you enter ="1">4830 the answer will be TRUE also

Has that anything to do with your question?

I think because you have two variants no implicit type coercion occurs but I cannot recall seeing that documented (although the Let coercion rules for Variants in the Runtime semantics section of the VBA language spec would imply no coercion should occur, which makes sense since neither variable is of a more specific type and therefore there can be no indication as to whether the comparison is intended to be on a string or numeric basis)

edit: reading further into the spec, it does explicitly state (below table 5.61)

There is an exception to the rules in the preceding table when both operands have a declared
type of Variant, with one operand originally having a value type of String, and the other
operand originally having a numeric value type. In this case, the numeric operand is considered
to be less than (and not equal to) the String operand, regardless of their values.