Forum Discussion
Incorrect calculation
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
Excel 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.
2 Replies
Excel 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.
HansVogelaar Thank you for the explanation and suggestions.
The first suggestion addresses my issue.
