Thread: Sort a text column that contains alphanumeric
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Maureen Maureen is offline
external usenet poster
  
Posts: 32
Default 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?
Reply With QuoteReply With Quote