And not just the sort warning for adjacent data found, but also the sort
warning for "numbers and numbers stored as text". These should be
independently set. I am working with a worksheet that has, for example, zip
codes, with leading zeroes. In order to preserve the leading zeroes I must
either put in some funky custom formatting (which I don't want to do) or I
just make the column text. Usually when I am working with this sort of thing,
I don't care if these columns sort as numbers or as text, because I am doing
data cleanup where I am more interested in grouping and unusual values than
in the exact order.

I can't tell you how many times the "new features to help those poor stupid
Office users do their work better" have resulted in total aggravation for me,
someone who DOES know how to use software. I don't want my hand held. I don't
want to be taken places I don't want to go. And I don't want 'help' coming up
EVERY SINGLE FNOODLING TIME I'm doing something in my normal workflow,
requiring me to answer stupid questions when I want to work smoothly and
efficiently.

For what it's worth, I like the warning about adjacent data when I'm
sorting. But one should always have the ability to turn off warnings and
features one doesn't like.

-ESquared

"mzehr" wrote:

This is just a suggestion to MS. Feel free to add your opinion if you wish.
Excel should offer a feature to allow experienced users to disable the sort
warning in Excel 2003 that pops up everytime you select a range that has info
in any of the cells contiguous with that range.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc