The problem I'm having is that I want a cell (A5) to equal the final 2 numbers of another cell (D2). I tried using the =right fx, and the =mid(find) fx. I'm running into a problem because the two digits I'm trying to pull are part of a decimal (1.060). So I want A5 to equal 60, but instead it just keeps giving me 6 or 06. If I change 1.060 to 1.063 it adjusts and gives me 63.

Any ideas on how to tell Excel to give me that zero?

Thanks!
-Dave