sort list/range of number with special characters

dear excelforum,

there is a list/range of data

as ...

100/2012
2/2012
3/2012
99/2012
22/2012
33/2012

when i am trying to sort ascending the list as per column a , it shows the following

100/2012
2/2012
22/2012
3/2012
33/2012
99/2012

_______

the sorting way i am requesting, should be as follows...

2/2012
3/2012
22/2012
33/2012
99/2012
100/2012


thank you.

dear excel forum,

to ace_xl
it does not work, the error is #value!
the cell/range is formatted as text, does that matter
also, will the above formula work if the data includes /2012, /2013, /20122,
/20133

to cutter
forum moderator
i did try to delete the repeated thread, i clicked delete thread, but the
system did not seem to accept that
as you can see there were repeated twice!

thank you