Result returning as string not long

[Shadow123]

Hi im using the below code to set a value in a larger macro.

leg2 should return a value of 0.23 in this case... now if i Dim leg2 as long i get nothing, if set it as a string then the value populates.

My question is, how can i make the result a number, even if it looks like text.

If rCell.Value = Cell.Offset(0, 1).Value Then
      leg2 = rCell.Offset(0, -19).Value
      Exit For
End If

If it helps in a formula i'd put = V( )to do this...

 

[Shadow123]

okay, now i feel stupid.... val .... two more letters lol

 

[Dryver14]

I managed to get it see 0.23 by Dim leg2 as variant

 

[Rick Rothstein]

leg2 should return a value of 0.23 in this case... now if i Dim leg2 as long i get nothing, if set it as a string then the value populates.

My question is, how can i make the result a number, even if it looks like text.

You cannot Dim it as Long (or even Integer) as those data type can only hold whole numbers and 0.23 is not a whole number. While you could Dim it as Variant, the better choice would be to Dim it as a Double (you could also Dim it as a Single, but Double gives you more flexibility as to the size of the number you can store in the variable).

 

[Shadow123]

ahhhh well there you go, i thought long was number... didnt know it wasn't for decimal numbers thanks guys