View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default 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