If the numbers are in column A, put this in B1 and copy down.

=RIGHT(A!,2)

Then do Copy PasteSPecial values on column B to get rid of the formulas.

Then sort on column B

Or, if you don't have the time, space or patience to do that and need to do
this sorting frequently, perhaps Jim Cone's fine commercial Add-in called
"SpecialSort" would do for you. It's available at:
http://www.realezsites.com/bus/primi...e/products.php

Vaya con Dios,
Chuck, CABGx3


"Tony" wrote:

I would like to sort a group of numberic numbers (1234567) by the last two
numbers (i.e. 67) How do I do this?