Is Split Buggy? Why Isn't 0 a Number?

[Tygur]

NotLKH, let's look at this part of your first code:

Select Case One
    Case ""
        MsgBox "NULL"
    Case "+"
        MsgBox "PLUS"
    Case IsNumeric(One) = True
        MsgBox One & " is a Number"
    Case Else
        MsgBox One & " is Not a Number"
End Select

Let's assume One is "1". Then we can evaluate that IsNumeric case like this:

Select Case One
    Case ""
        MsgBox "NULL"
    Case "+"
        MsgBox "PLUS"
    Case True 'IsNumeric(One) = True
        MsgBox One & " is a Number"
    Case Else
        MsgBox One & " is Not a Number"
End Select

Because IsNumeric("1") is true, (IsNumeric(1) = True) is also true. So in the end it looks like the select case statement is comparing "1" with True. We all know "1" does not equal True. Does this make sense now?