Hi
is this a long or short list. For the latter you could use a helper
column with formulas which sort your original data

--
Regards
Frank Kabel
Frankfurt, Germany

"Slumbering Gorilla"
schrieb im Newsbeitrag
...
unfortunatly my sourcelist is part of a table. and reorginizing it
will take
days. but if it comes down to it i will have to do that. but i just
added a
data validation list, and not having it in alphabetical order makes
it pretty
much useless due to the number of names in it. so i was trying to
avoid
retypeing the table.

"Frank Kabel" wrote:

Hi
you need a sorted source list :-))

--
Regards
Frank Kabel
Frankfurt, Germany

"Slumbering Gorilla"
schrieb im Newsbeitrag
...
how can i make my data validation list drop down, display my city
names in
alphabetical order?