Converting a variable from text to numeric in VBA

[450nick]

Hi all,

I have the following piece of code which pulls a number (in this case "2") from a string, which I want to load into an array. Later on I want to add other numbers to this and have noticed that I'm getting 2+2 = 22 instead of 4 and this appears to be because the number is being treated as a string. What's the simplest way to convert the variable to a number?

Res(R, 3) = Mid(Res(R, 0), Len(Res(R, 0)) - 3, 1)

The Array "Res" will hold numeric and alphanumeric in different columns so I don't think I can make the whole array numeric

 

[lrobbo314]

[COLOR=#333333]Res(R, 3) = Int(Mid(Res(R, 0), Len(Res(R, 0)) - 3, 1))[/COLOR]

 

[Peter_SSs]

In your case you could also use

Res(R, 3) = CLng(Mid(Res(R, 0), Len(Res(R, 0)) - 3, 1))

 

[450nick]

Perfect, thanks chaps!