Phil - It sounds like you're storing the number as a text field? You may want to try using a custom column on the report then (yes, text mode) using valueexpression=NUMBER({MyFieldName}) to convert the string to a number, then you should be able sort as needed.