Thanks for posting back with the resolution.


Gord

On Wed, 4 Jun 2008 12:43:02 -0700, Kimmy T
wrote:

I was trying to sort a list of cooler manufacturers alphabetically, the name
in the cell that wouldn't sort was True. After posting this question and
talking to several other people, I changed the name in that cell to True Mfg,
now it sorts correctly. I guess it has to do with the "logical sort order"
where FALSE will be sorted before TRUE (per Excel help). I made up a new
spread sheet of words including true & false, true always ended up at the
bottom of the list and both words would change to caps. Thank you for taking
the time to respond to my post.