Sorting Percentage From High to Low

[Anonymous]

In line 35 without applying FORMAT() function the total scores are sorted correct.

The moment when I apply the FORMAT() funtion to change the scores to percentage it is no longer sorted according, what could be the reason for that?

[tamerj1 · Accepted solution]

Hi @Anonymous 
This is text. The comparizon starts from the first letter from the left. 1 is the smallest and 9 is the greatest. You can do something like