Tim,

Oops. Don't do that as I said. If your list starts in A2, the formula
should be:
=TEXT(A2,"00000")
--
Earl Kiosterud
www.smokeylake.com

"Earl Kiosterud" wrote in message
...
Tim,

You need an alphabetic sort, but your 5-digit zip codes are numeric. You
can convert them all with a helper column. Presuming the list is in A2
and down:

=TEXT(A1,"00000")

Copy down with Fill Handle.

Now to permanently convert the originals, select all of helper column,
noting which cell your selection started, Copy. Select the corresponding
(first) cell in the original column. Edit - Paste special - values. You
no longer need the helper column. Now sort.
--
Earl Kiosterud
www.smokeylake.com

"Tim C" wrote in message
...
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