Sorting Percentages in decending order.

[peterwithingtonuk]

I am sorting a selection of data that has been brough into my sheet via vlookups that are percentages. I am after putting together a leaderboard and have noticed that my sort, whether it be via a macro or by manually selecting the sort tool, puts 100% below lower percentages.

Please can I get some help on this as its really holding up my day and potentially making me bold from pulling my hair out!!!

[DonkeyOte]

It sounds as though the values being sorted are stored as text rather true numbers - can you post a sample ?

EDIT: disregard that - are the values you're trying to sort formulae ?

[peterwithingtonuk]

Yeah its coming from another sheet.