I'm afraid I must not have made myself clear. I understand that "a to z"
isn't good for sorting dates. My problem is that once, and only once, I saw
"oldest to newest" and "newest to oldest" as sort menu options. But never
again. How can I get the menu options back? I know I saw them, because I
was so pleased that Excel understood that "a to z" wouldn't work for dates.

"Luke M" wrote in message
...
Sorting "A to Z" means to sort in ascending order. As dates increase in
value
as time goes on, sorting A to Z would place your dates in oldest to newest
order. Some sorting differences may occur based on whether you have header
rows selected, or how much data you have selected before attempting your
sort.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Laurel" wrote:

I have a little spread shee with a column called "date" that contains
dates
in a "*3/14/2001" format. That's what I see when I highlight all its
cells
and click "format cells." I'm accustomed to sorting by clicking on the
column header and then the "sort xxx to xxx" icon. Five minutes ago I
did
this and was offered "sort oldest to newest" and "sort newest to oldest"
menu items. I don't know exactly what I did after that, but now when I
try
to do the same thing I'm only offered "sort A to Z" and "Sort Z to A."
This
doesn't work out right, of course. What's going on?

TIA
LAS


.