Sorting is not properly done.

Because that is correct.

You will need to make your entries like this for it to sort differently:

A-01
A-02
A-11
 
Hi ALiGW!

It's like Excel. Thank you so much!

* Is there any other way?
 
There may be a way of making Excel do it incorrectly to suit you, but it will be complex, and it would be far better for you to understand what is correct and why and adapt your data to suit.

Hope this helps. :)
 
You must log in or register to reply here.
Back
Top