View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AshMorK AshMorK is offline
external usenet poster
 
Posts: 24
Default Text string to a number

The following function returns a text..but i want to get it as a number:

Public Function Gmid(vin)
If Mid(vin, 12, 1) < "A" And Mid(vin, 12, 1) 0 Then
ID = Right(vin, 6)
Else
ID = Right(vin, 5)
End If
Gmid = ID
End Function

Thanks in advance x your help!

AhsMorK (chile)