Format the column with the account numbers as text then it will sort as you
desire.
"Erika" wrote in message
...
I have a listing of account numbers, for example
103, 104a, 103a, 104, etc.
How do I get them to sort 103, 103A, 103B, 104, 104A, 104B?
Currently it is sort all the numbers and then putting all of the numbers
and
letters together at the end.
|