I am busy with a list of movies which I put into my Calc-document.
Problem: I can’t get it sorted alphabetically allright.
I have setup all my cells (cell layout) to “Text” and aligned all cells to “Left”.
I mind all spaces at the front so that is not the problem for sorting (a.k.a no spaces at front)
It sorts my movielist now as follows:
10 Cloverfield Lane
30 Days Of Night
30 Minutes Of Less
300: Rise Of An Empire
Calc refuses somehow to sort 300, 1408 and 2012 correctly even when I put those movietitles at the very bottom of column A (1740 rows), or for example put both 300 movies after eachother at the correct place.
Does anyone have suggestions?