Sort a text column that contains alphanumeric
 

I want to sort the following which is all formatted as text:
REA240
REA250
CAP010
TIP031
CUP001

When I hit sort, it converts everything to numbers, although it is still
formatted as text, so I end up with the column looking like:
221001
221041
221051

How do I prevent it from chaning my fields?

Sort a text column that contains alphanumeric
 

You sure that those values didn't just get sorted to where you were viewing?

Did you have any hidden rows where they might have popped up from?

Maureen wrote:

I want to sort the following which is all formatted as text:
REA240
REA250
CAP010
TIP031
CUP001

When I hit sort, it converts everything to numbers, although it is still
formatted as text, so I end up with the column looking like:
221001
221041
221051

How do I prevent it from chaning my fields?

--

Dave Peterson