If you want it sorted as text, then you have to change the format to text.
There is no option to sort as text or numbers. There is a small glitch I
noticed that when you changed the cells' format to text it still sorts it as
numbers. You have to manually double click on each cell and hit enter to
make the format "set in". After you do this it will sort as text.

There are ways to avoid this problem in the future. 1) change the cells
format you know are text before you begin typing. 2) use an apostrophe
before all numbers to tell the computer it is text; it outputs it without the
apostrophe (For Example type '12 instead of 12).

hope this helps!

"Tim C" wrote:

Excel 2003

When I sort a list that contains text that looks like numbers, I am NOT
getting the pop-up asking if whether I want them to sort as numbers or text.
It just automatically sorts text that looks like numbers as numbers, which
is not what I want.

Any ideas?

Thanks,
Tim C