Aug 13 2022 01:27 PM
Cell A1 1.16.11
Cell B1 1.16.9
Cell C1 =B1<A1
Result is false but should be true, 1.16.9 is less than 1.16.11
Aug 13 2022 01:44 PM
SolutionExcel treats these values as text, so it sorts them alphanumerically, not as numbers. 11 comes before 9 since 1 comes before 9.
One workaround is to use 1.16.09 instead of 1.16.9.
Another is to use Data > Text to Columns, with point (dot, period) as delimiter. and sort on the resulting columns.
Aug 19 2022 03:12 PM
@Hans Vogelaar Thank you for the explanation and suggestions.
The first suggestion addresses my issue.
Aug 13 2022 01:44 PM
SolutionExcel treats these values as text, so it sorts them alphanumerically, not as numbers. 11 comes before 9 since 1 comes before 9.
One workaround is to use 1.16.09 instead of 1.16.9.
Another is to use Data > Text to Columns, with point (dot, period) as delimiter. and sort on the resulting columns.