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