I have a situation where there are scores that are numerical and they also have + and -
Currently I have set field as deciaml so it sorts and the + - are ignored or trucated.
Is it possible to define a search where the first 2 or 3 digits max score 100 are sorted then sort by the + or minus
Excel cannot cope with this either see image below.
Cheers Chris