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?