I try get the 3 highest numbers so I sort an array by the value but two digit numbers appear higher in the sorted list then three digit numbers.
In the first pic you can see the row numbers and the value in row 5.
In the second pic you can see that the value 81 for example is listed above the value 528 in the sorted list.
Does anyone know what the problem is?
Thanks for your answer. How can I convert the values to number values?
I added a screenshot of my scenario. I’m getting the values from google sheet, make an array an d sort it.
I added a leading 0 in google sheets and that doesn’t work. I also have some negativ values and with the ‘0’ added in front they look like this for example ‘0-22’
The easiest way is to change the value render option to “Unformatted value”