On Thu, 23 Mar 2006 10:59:03 -0600, mrsinnister
<
[email protected]> wrote:
>
>*- 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.-*
It is not clear to me how you want the output sorted.
If what you are storing is really a date, and not the textual representation of
a date, then the cell format has NO relevance to the sort order.
If you want your values sorted by date, from earliest to latest, you just sort
it ascending. If that doesn't work, then your data is NOT really a date, but a
textual representation of same, and you will have to change it. You can prove
this by executing the formula
=ISTEXT(cell_ref)
where cell_ref is the location of an incorrectly sorted date.
If you want to have your output grouped by days of the week, or months, or
something different than sorting in date order, you'll have to post back with
more info.
--ron
Bookmarks