Hi people,
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 300 1408 2012 10 Cloverfield Lane 30 Days Of Night 30 Minutes Of Less 300: Rise Of An Empire
etcetera
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?
Cheers, Geeviz.