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.