Sort error.jpg

So, as per the attached pic you can see my issue.

This is only part of a much larger spreadsheet, so manual manipulation is a no-go.

I wonder if Excel can even sort this.....no-one seems to thinks so, they think I have to remove the hyphen!
Then my numbers will be corrupted.

Any thought anyone?