| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort alphanumeric | Excel Discussion (Misc queries) | |||
| Alphanumeric Sort 1, 1a | Excel Discussion (Misc queries) | |||
| sort alphanumeric | Excel Discussion (Misc queries) | |||
| Sort - alphanumeric. | New Users to Excel | |||
| Alphanumeric Sort | Excel Discussion (Misc queries) | |||
Hybrid Mode
