View Single Post
  #2   Report Post  
Jim
 
Posts: n/a
Default

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.