View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Are you kidding me??? Are you telling me I can't sort format: dddd, mmmm dd, yyyy?

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