Sort numbers in text strings by full number rather than first character

If there are numbers as Text strings, they are ordered by the first character rather than the whole number. e.g. 31 will come before the number 4 (because the first character is a 3, which comes before 4). This makes sorting by number value impossible unless the field is set to Number, which is not always possible.