If you want to perform calculations on your results (e.g. SUM), then you'll need to modify the formula to
=RIGHT(A1,2)+0
or RIGHT(A1,2)*1 or
RIGHT(A1,2)/1