When sorting cells with numbers in % format in descending order it sorts single digit numbers first from highest to lowest and than higher double digit numbers from highest to lowest. How can this be corrected to sort all in sequence?
LibreOffice version?
File format?
Data type (text or numeric)?
Usually this hints to your numbers not recognized as numbers, but as text/string.
.
Solutions depend on the data. If it is imported csv-data, you may repeat the import and have a look at the checkbox for “detect special numbers”.
Another option is to use “text-in-columns” to trigger the conversion or deleting the usually shown apostrophe ’ at the beginning with nothing ( Regular expression: search for '(.*) and replace with $1