test to confirm non-numeric characters
did you try
If IsNumeric(your_variable) Then
MsgBox "ok"
Else
MsgBox "not ok"
End If
--
Gary Keramidas
Excel 2003
"Fan924" wrote in message
...
I have a 10 character number string. I need a test to confirm that
there are no non-numeric characters in this string. Thanks
Excel97
|