I would just convert it.... why wouldn't you?
Anyway, after looking at how ISBN Validation works, I did this:-
Code:
Function CheckISBN(x)
Length = Len(x)
If NOT (Length > 10 Or Length = 0) Then
intValue = 0
For Counter = 10 To 1 Step -1
If Counter <= Length Then
intValue = intValue + (Counter * Mid(x, ((-1 * Counter) + Length + 1), 1))
End If
Next
CheckISBN = (intValue Mod 11 = 0)
Else
CheckISBN = False
End If
End Function
I admit, I have not accounted for the X's that are allowed in ISBN numbers, and the function will fall-over if it comes across an X in an ISBN.... but hey, I didn't want to strip the entire challenge away from you!!
I've started you off, so just fill in the last bits!!
Rob