Sort mixed numbers/letters

How can I sort by a row of numbers with mixed formats? I have numbers such
as 1, 2, 3 and 10, 22, 27 and 11-A, 20-D, 34-D etc. Currently, no matter how
I format the cells, they sort by first number, then second, then the numbers
with letters (1, 10, 2, 22, 27, 11-A, 20-D etc.). I can't seem to find a way
to get the column to sort by the actual value (1, 2, 3, 10, 11-A, 22, etc.)
Please...any help you can give me. Thank you.

See your other post

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"V-ger" <[email protected]> wrote in message
news:[email protected]...
> How can I sort by a row of numbers with mixed formats? I have numbers
> such
> as 1, 2, 3 and 10, 22, 27 and 11-A, 20-D, 34-D etc. Currently, no matter
> how
> I format the cells, they sort by first number, then second, then the
> numbers
> with letters (1, 10, 2, 22, 27, 11-A, 20-D etc.). I can't seem to find a
> way
> to get the column to sort by the actual value (1, 2, 3, 10, 11-A, 22,
> etc.)
> Please...any help you can give me. Thank you.