simple edit string question

If your asking how to convert a string to a number then:

Private Sub Form_Load()
    Dim Testies As String
    Testies = "99876"
   
    Dim Balls As Double
    Balls = CDbl(Testies)
   
    Dim Nads As Long
    Nads = CLng(Testies)
   
    Dim Nuts As Single
    Nuts = CSng(Testies)
   
    MsgBox Testies & " < " & (Balls * Nads * Nuts)
End Sub

Idle_Mind

lol!

when you say you want to get rid of the ' and only have 99876, do you mean you have a STRING value, and you want to convert it to a NUMBER?

How do you ge the value as Testies = '99876'  ?  since the ' character acts as a Comment

What exactly are you trying to accomplish, as your explanation is VERY confused.

AW

oh, bear in mind the value will still be a String and NOT a number

for that, extract the ' using the code i mentioned and then use the conversion techniques by Idle_Mind

I know what he means. He wants to convert a String to an Integer

Balls = Val(Testies)

That's it.
The power of the single lined code reveals itself.

Hope it works,
Burningmace

> I know what he means. He wants to convert a String to an Integer
>
> Balls = Val(Testies)
> 
> That's it.
> The power of the single lined code reveals itself.
>
> Hope it works,
> Burningmace

Except that an Integer can only hold from -32,768 to 32,767.  

So in your case burningmace, the Val() function would return a Long, not an Integer like you said.

Dim Testies As String
Testies = "99876"
Balls = Val(Testies) ' <----- Balls was not declared, so it implicitly becomes a Long

< versus >

Dim Testies As String
Testies = "99876"
Dim Balls As Integer
Balls = Val(Testies) ' <---- Overflow Error

"The power of the single lined code reveals itself."  ---> Translation: Lazy coding causes unexpected results.

Idle_Mind

sorry for the late reply.  something came up.

and sorry i didnt explain my question better guys.  i am pulling the info with an array from a .log file.  what i pull out is '9987' (which is how it shows in the .log file) i simply needed to get rid of the 's.

bad_seed.  Mid(test, 2, (Len(test) - 2)) is exactly what i needed.  thank you.  i had been trying to use replace, len, etc but was not using them properly.

thanks again for the help guys.