Forum Discussion
Sorting of values
Hi, I have a spreadsheet that contains the values below. Ver 5.29.1 5.29.1 5.29.1 8.03 8.02 8.02 The above is correctly sorted in Excel. When I create a data...
HI avidthinker The issue is beacuse some of the values are traeted as text i guess in your case the one with 2 decimal points be treating as text and the other as number so the text is sorted alpahbetically and the other is sorted numerically so to overcome this you cold conevert evrything to text Like Text.From and then padd the other values to match them and sort accordingly i guess