Trying to sort several part numbers - example
23476
1237X
1237A
355E2
351E3
74477
111E6

It will not sort correctly because of the numbers are treated seperately and
the =TEXT(ref cell, "format") function treats the part #'s with "E2" or "E3"
(basically E#) as scientific notation. Rekeying is not an option, as the
actual sheet has several thousand of these types of mixed alpha numerics. It
worked properly in Excel 2002 and Excel 2000, Excel 2003 has changed the
whole thing!.
--
/billd