if it's always 2 last digits use:
=RIGHT(A1,2)*1

"Am I right in suspecting that in cells containing a mix of letters
and
numbers, Excel does not treat the number as a number but rather as
general
text?"
yes, you are