Comparing slightly different strings
 

If the variables are actually dimensioned as String type, it should
work:

Code:
--------------------
Dim Nums1 As String, Nums2 As String

Nums1 = "12341234123"
Nums2 = "1234.123.4123"
If Nums1 < Nums2 Then
MsgBox "Not the same"
Else
MsgBox "They match"
End If
--------------------

Hope this helps,
theDude


--
theDude
------------------------------------------------------------------------
theDude's Profile: http://www.excelforum.com/member.php...o&userid=16550
View this thread: http://www.excelforum.com/showthread...hreadid=391086