In microsoft excel how do I put numbers in numerical order by the last two digits?

there is not a direct way, but what you can do is in the column next to it enter this formula referencing your data cell (replace A1) in the original column =RIGHT(A1,2). Then highlight both columns and sort by your new column in ascending order.