Even though you formatted the cells as text, it appears the integers were
entered as numbers. Note that if you first format cells as text, then input
your example values, they will sort the way you are wanting.

to quickly convert your column to text, you could use a helper row with:
=TEXT(A1,"@")
and copy down. Then do a copy - paste special values to create a static list
of text numbers that you can now sort.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Paul Kraemer" wrote:

Hi,
I am using Excel 2007. I have a worksheet one which one of my columns
contains mostly numerical data, but I have this column formatted as Text.
The data in this column is basically a series of integers, but for certain
integers I have a second row for which I have appended an asterisk (*) to the
end of the integer value. For example, my data might look like this:

1001
1002
1002*
1003

I would like to be able to sort my data as I've shown above, but I can't
figure out how to do this. Anytime I try to sort on this column (sorting by
values from smallest to largest), I get the following order:

1001
1002
1003
1002*

If anyone can tell me how I can sort and get the order that I want, I would
really appreciate it. Thanks in advance,

Paul
--
Paul Kraemer