How's this for a crazy solution:

Dim x as Integer

x = Left(Right(Sheet1.Range("A1").Text, 2), 1)

I think that returns what u want??


"Howard31" wrote in message
...
Hi All,

I have the value 1.0020 in a cell, I want to assign the second right
decimal
(2) to an integer variable, how do I do that?

Any help will be very much appreciated