Sort Records On Numeric Values Stored. Starting with will appear before values that start with. Following are some tricks that I have found useful for sorting numeric data that is stored as strings.
Go to Sorting tab. Sort records on numeric values stored in a text field Do you see records sorted on the individual digits and not on the numeric value. Sorting Numeric Values That Are Stored As Strings.
Sorting can also be done based on multiple columns.
In other words numbers will be sorted based on the individual digits that make up the value instead of on the numeric value. Following are some tricks that I have found useful for sorting numeric data that is stored as strings. In this case numbers will be sorted in alphanumeric order rather than numeric. In other words numbers will be sorted based on the individual digits that make up the value instead of on the numeric value.
