?????

I believe there may be a better way, but try comparing using CLng (convert
to long):

Sub test()
Dim str As String
Dim num As Long

str = "1"
num = 1
Debug.Print CLng(str) = CLng(num)
End Sub

hth,

Doug


"Dale" wrote in message
...
Problem. I'm trying to find a match between two arrays and have run into a
problem. Two sheets, value is 62113 in both and the cell format is
general.
Sheet1 has been imported using VBA and 62113 appears left justified to the
eyes. Sheet2 has been manually entered and appears right justified.
My code is showing the first value as 62113, sheet1, and "62113" for
sheet2.
What could the problem be and the fix ?

Signed ?????