=RANK(B2,B$2:B$15,0)

My guess is that B2 doesn't contain an Excel number value, but instead contains an Excel text value that looks like a number.

One way to fix this is by wrapping it this way in B2:
=--(Whatever_is_in_B2_now)