Sort a text column that contains alphanumeric

M

Maureen

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?
 
D

Dave Peterson

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?
 
Top