Sorting on column with numbers (and a few letters)

CALC SS with 6,000 rows, 5 Columns.
Column #3 has numbers and a couple of letters.
Formatted several ways; General number, TXT, etc.
Sorting the SS on that column results in 19, 19, 19, 22, 22, 22, 39, 39, 39, 2, 2, 2, …
Not useful.

Any ideas?

Thanks, as always,
⌡im

When you sort, in the Options tab, mark Enable natural sort.

LO 7.0.6.2.

2 Likes

Thank you.
Such a simple solution … Had to format as Number/General
Thanks
⌡im [THE BookMan]