| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting goes E100,E1001,E101 not E100,E101 etc. Why???
Even trying Text,Numbers,General in the Format is giving me the same results.
ie E110,E1101------E1109 THEN E111 E1111 etc It appears that the numbers are being treated in some type of formula.Could it be that the combination of alpha and numeric is causing a peoblem? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting goes E100,E1001,E101 not E100,E101 etc. Why???
To me they don't look like numbers, they look like text strings, so Excel
will sort them alphanumerically. If you've always got the one prefix letter, you may be able to get away with splitting the number part into a helper column, and sorting by that; Excel kindly gives you the option that anything that looks like a number is sorted as a number. -- David Biddulph "MEANLEANDEANE" wrote in message ... Even trying Text,Numbers,General in the Format is giving me the same results. ie E110,E1101------E1109 THEN E111 E1111 etc It appears that the numbers are being treated in some type of formula.Could it be that the combination of alpha and numeric is causing a peoblem? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting goes E100,E1001,E101 not E100,E101 etc. Why???
E110,E1101------E1109 THEN E111 E1111 are strings for XL. If you want to sort by numbers represented by characters after E then use a helper column filled with formula =VALUE(MID(A2,2,256)) (supposed that your data are in column A) and sort by this helper column! Regards, Stefi €˛MEANLEANDEANE€¯ ezt Ć*rta: Even trying Text,Numbers,General in the Format is giving me the same results. ie E110,E1101------E1109 THEN E111 E1111 etc It appears that the numbers are being treated in some type of formula.Could it be that the combination of alpha and numeric is causing a peoblem? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting goes E100,E1001,E101 not E100,E101 etc. Why???
BINGO. Thanks a lot.
"David Biddulph" wrote: To me they don't look like numbers, they look like text strings, so Excel will sort them alphanumerically. If you've always got the one prefix letter, you may be able to get away with splitting the number part into a helper column, and sorting by that; Excel kindly gives you the option that anything that looks like a number is sorted as a number. -- David Biddulph "MEANLEANDEANE" wrote in message ... Even trying Text,Numbers,General in the Format is giving me the same results. ie E110,E1101------E1109 THEN E111 E1111 etc It appears that the numbers are being treated in some type of formula.Could it be that the combination of alpha and numeric is causing a peoblem? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting goes E100,E1001,E101 not E100,E101 etc. Why???
Thanlks a lot.
"Stefi" wrote: E110,E1101------E1109 THEN E111 E1111 are strings for XL. If you want to sort by numbers represented by characters after E then use a helper column filled with formula =VALUE(MID(A2,2,256)) (supposed that your data are in column A) and sort by this helper column! Regards, Stefi €˛MEANLEANDEANE€¯ ezt Ć*rta: Even trying Text,Numbers,General in the Format is giving me the same results. ie E110,E1101------E1109 THEN E111 E1111 etc It appears that the numbers are being treated in some type of formula.Could it be that the combination of alpha and numeric is causing a peoblem? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting goes E100,E1001,E101 not E100,E101 etc. Why???
You are welcome! Thanks for the feedback!
Stefi €˛MEANLEANDEANE€¯ ezt Ć*rta: Thanlks a lot. "Stefi" wrote: E110,E1101------E1109 THEN E111 E1111 are strings for XL. If you want to sort by numbers represented by characters after E then use a helper column filled with formula =VALUE(MID(A2,2,256)) (supposed that your data are in column A) and sort by this helper column! Regards, Stefi €˛MEANLEANDEANE€¯ ezt Ć*rta: Even trying Text,Numbers,General in the Format is giving me the same results. ie E110,E1101------E1109 THEN E111 E1111 etc It appears that the numbers are being treated in some type of formula.Could it be that the combination of alpha and numeric is causing a peoblem? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Sorting Sorting | Excel Discussion (Misc queries) | |||
| Sorting Data in ascending order | Excel Discussion (Misc queries) | |||
| sorting non contiguous ranges | Excel Discussion (Misc queries) | |||
| Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . . | Excel Discussion (Misc queries) | |||
| SORTING question | New Users to Excel | |||
Linear Mode
