Sorting column A in sorting.ods (9.6 KB) with the following settings:
Can anyone see why the sorting results are unexpected (rows 9 and 32)?
Enable natural sort means “try to find numbers in the text, and use those numerical values”. And 4e0 is a special numeric notation, meaning 4*10^0, i.e. simply 4. So for the sorter, the list looks like
=j3a
=j3b
=j4
=j4a0
=j4a1
(=j4 instead of =j4e0)
2 Likes