Can excel grab/use LSB in an equation

[Sparky81]

Hard to explain so I will give an example.

A series of equations gives way to an answer of 436. I want to grab only the 36 and place it in another cell.

If the number calculated was 1245, I still only want the 45.

Any ideas if this is possible?

 

[kpark91]

Formula:
If answer is in A1

   =Right(A1, 2)

 

[JackDanIce]

Try:

=RIGHT(A1,2)+0

 

[VoG]

Try

=RIGHT(A1,2)+0

 

[kpark91]

I think I've asked this question before..
does "+0" set the result as a number??

 

[Sparky81]

And you all come through again. Quickly I might add. Thank you!!

 

[VoG]

I think I've asked this question before..
does "+0" set the result as a number??

Yes