VBA Equivalent of =VALUE( ?

[JazzSP8]

Hi All

Hopefully something quick, I want to convert a text value to a number value in VBA so that something listed as '01' will convert to '1'

So, if in A1 I had '0123ABC' I could extract that with =VALUE(LEFT(A1,2)) to give me a 1

What do I need to add to this to make it do the same?

VOUCHERDATE = Left(cell.Range("A1"), 2)

Thanks

 

[JamesW]

Hi there,

Try:

VOUCHERDATE = Left(Range("A1").Value, 2) + 0

 

[VoG]

Or

VOUCHERDATE = Val(Left(.Range("A1"), 2))

 

[JazzSP8]

Ah! - Excellent, thanks both