Hi
Excel stores dates as numbers, so today is 38799.
If you want to sort by bits of the date in a particular order, you'll have
to use helper columns with those 'bits' in - and sort on those.
Andy.
"mrsinnister"
wrote in message
...
*-
Well, I am completely stuck. My regional settings are in order.
I place the aforementioned format into my Custom format list, but I
can't find a way to get this column to sort using the Weekday, Month
Day, Year format. Can ANYONE provide any suggestions?? I mean
anyone?? Did I break some kind of code by posting on a similar problem
with someone else that I wasn't aware of. Do you all just not know, or
you think the solution is so simple as to not warrant a response?
Enlighten me. I have thick skin.-*
--
mrsinnister
------------------------------------------------------------------------
mrsinnister's Profile:
http://www.excelforum.com/member.php...o&userid=32737
View this thread: http://www.excelforum.com/showthread...hreadid=525764