Give this a try...

=MOD(1000*A1,10)

--
Rick (MVP - Excel)


"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