I have a worksheet that I need to sort by terminal digits (last 2 digits).

The data is in column A in the format:

'0004135296

Notice the ' at the beginning.

I need to sort this data by the 96 at the end.

Thanks.