Text string to a number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Public Function Gmid(vin) As Long
_______________________________________________________________________
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract 5 digit number from string 24
BeforeUpdate to determine length of entry and allow or not the entry 0
Select query numbering results 4
Highlight Text In A Textbox 3
SQL or maybe a hardware issue for finding lowest Repair order date or mileage 1
alpha AND numeric, best way to set up 2
Compare 2 list macro 1
Copy from combo box to text box 3

Back
Top