Excel 2003 / Windows Explorer (XP) sort order differs - How to fix?

In Excel 2003,

mpeg2_MP@H1440_1280x720p_29.97fps_CBR_40Mbs_openGOP_zzscan.mpv
comes before
mpeg2_MP@H1440_720x576i_25fps_CBR_45Mbs_closedGOP_alternatescan_LFF.mpv

In XP's Windows Explorer and also using DIR/ON in a command prompt
shell window, the sort order is reversed.

How do I reconcile the two so they sort in the same order?

Thank you kindly.

sgopus
Thu Mar 13 16:35:03 CDT 2008

Try this group instead

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.excel.misc&cat=en_US_34a4dcef-6aac-414e-9881-2ba33de8be2f&lang=en&cr=US

"John Bartley K7AAY" wrote:

> In Excel 2003,
>
> mpeg2_MP@H1440_1280x720p_29.97fps_CBR_40Mbs_openGOP_zzscan.mpv
> comes before
> mpeg2_MP@H1440_720x576i_25fps_CBR_45Mbs_closedGOP_alternatescan_LFF.mpv
>
> In XP's Windows Explorer and also using DIR/ON in a command prompt
> shell window, the sort order is reversed.
>
> How do I reconcile the two so they sort in the same order?
>
> Thank you kindly.
>
>

John
Thu Mar 13 19:38:53 CDT 2008

> "John Bartley K7AAY" wrote:
> > In Excel 2003,
> >
> > mpeg2_MP@H1440_1280x720p_29.97fps_CBR_40Mbs_openGOP_zzscan.mpv
> > comes before
> > mpeg2_MP@H1440_720x576i_25fps_CBR_45Mbs_closedGOP_alternatescan_LFF.mpv
> >
> > In XP's Windows Explorer and also using DIR/ON in a command prompt
> > shell window, the sort order is reversed.
> >
> > How do I reconcile the two so they sort in the same order?
> >
> > Thank you kindly.



On Mar 13, 2:35 pm, sgopus <sgopus@discussions.microsoft.com> wrote:
> Try this group instead
> http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?query=sort+order&cboDiscussionGroup=en_US_34a4dcef-6aac-414e-9881-2ba33de8be2f%3Amicrosoft.public.excel.misc%3Aen%3AUS%3A%3A%3A%3A&=Go&dg=microsoft.public.excel.misc&cat=en_US_34a4dcef-6aac-414e-9881-2ba33de8be2f&lang=en&cr=US&pt=&catlist=&dglist=&ptlist=&exp=&sloc=en-us


It requires me to create an MSN Hotmail, MSN Messenger, or Passport
account. I have a surfeit of web accounts to memorize, and I think the
answer would be of benefit to the members of this USENET newsgroup
instead of shut up behind a walled garden, owned by M$.

Ben
Thu Mar 13 23:20:53 CDT 2008


"John Bartley K7AAY" <john.bartley@gmail.com> wrote in message
news:602b5cfa-2c98-46f1-8009-71c9a5ad42a7@u10g2000prn.googlegroups.com...
> In Excel 2003,
> mpeg2_MP@H1440_1
> comes before
> mpeg2_MP@H1440_7
> In XP's Windows Explorer and also using DIR/ON in a command prompt
> shell window, the sort order is reversed.

Install TweakUI
http://windowsxp.mvps.org/tweakui.htm
Highlight Explorer, scroll down to "Use intuitive filename sorting"
Uncheck it and click OK.

Bob
Fri Mar 14 07:56:21 CDT 2008



John Bartley K7AAY wrote:

>>"John Bartley K7AAY" wrote:
>>
>>>In Excel 2003,
>>>
>>>mpeg2_MP@H1440_1280x720p_29.97fps_CBR_40Mbs_openGOP_zzscan.mpv
>>>comes before
>>>mpeg2_MP@H1440_720x576i_25fps_CBR_45Mbs_closedGOP_alternatescan_LFF.mpv
>>>
>>>In XP's Windows Explorer and also using DIR/ON in a command prompt
>>>shell window, the sort order is reversed.
>>>
>>>How do I reconcile the two so they sort in the same order?
>>>
>>>Thank you kindly.
>
>
>
>
> On Mar 13, 2:35 pm, sgopus <sgopus@discussions.microsoft.com> wrote:
>
>>Try this group instead
>>http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?query=sort+order&cboDiscussionGroup=en_US_34a4dcef-6aac-414e-9881-2ba33de8be2f%3Amicrosoft.public.excel.misc%3Aen%3AUS%3A%3A%3A%3A&=Go&dg=microsoft.public.excel.misc&cat=en_US_34a4dcef-6aac-414e-9881-2ba33de8be2f&lang=en&cr=US&pt=&catlist=&dglist=&ptlist=&exp=&sloc=en-us
>
>
>
> It requires me to create an MSN Hotmail, MSN Messenger, or Passport
> account. I have a surfeit of web accounts to memorize, and I think the
> answer would be of benefit to the members of this USENET newsgroup
> instead of shut up behind a walled garden, owned by M$.

Actually it IS in the newsgroup, he just happened to point you at the
web interface to this USENET newsgroup. Which also happens to reside on
a server owned by Microsoft.

K7AAY
Fri Mar 14 10:26:56 CDT 2008

On Mar 13, 9:20 pm, "Ben Lucas" <ki...@invalid.edu> wrote:
> "John Bartley K7AAY" <john.bart...@gmail.com> wrote in messagenews:602b5cfa-2c98-46f1-8009-71c9a5ad42a7@u10g2000prn.googlegroups.com...
>
> > In Excel 2003,
> > mpeg2_MP@H1440_1
> > comes before
> > mpeg2_MP@H1440_7
> > In XP's Windows Explorer and also using DIR/ON in a command prompt
> > shell window, the sort order is reversed.
>
> Install TweakUIhttp://windowsxp.mvps.org/tweakui.htm
> Highlight Explorer, scroll down to "Use intuitive filename sorting"
> Uncheck it and click OK.

Oddly enough, version 2.0 was installed and had that attribute already
set before I reported the problem.

I checked the web page kindly provided, found a new version 2.1,
installed that, and 2.10 solved the problem.

Many thanks to Ben Lucas for pointing the way to the solution!

Ben
Fri Mar 14 19:18:10 CDT 2008


"K7AAY" <john.bartley@gmail.com> wrote in message
news:5d69e1e9-7902-4f99-823e-fc4fb74306c8@e23g2000prf.googlegroups.com...
> On Mar 13, 9:20 pm, "Ben Lucas" <ki...@invalid.edu> wrote:
>> "John Bartley K7AAY" <john.bart...@gmail.com> wrote in
>> messagenews:602b5cfa-2c98-46f1-8009-71c9a5ad42a7@u10g2000prn.googlegroups.com...
>>
>> > In Excel 2003,
>> > mpeg2_MP@H1440_1
>> > comes before
>> > mpeg2_MP@H1440_7
>> > In XP's Windows Explorer and also using DIR/ON in a command prompt
>> > shell window, the sort order is reversed.
>>
>> Install TweakUIhttp://windowsxp.mvps.org/tweakui.htm
>> Highlight Explorer, scroll down to "Use intuitive filename sorting"
>> Uncheck it and click OK.
>
> Oddly enough, version 2.0 was installed and had that attribute already
> set before I reported the problem.
>
> I checked the web page kindly provided, found a new version 2.1,
> installed that, and 2.10 solved the problem.
>
> Many thanks to Ben Lucas for pointing the way to the solution!


I'm gald you got it fixed!

Frank
Sat Mar 15 07:32:20 CDT 2008

"John Bartley K7AAY" <john.bartley@gmail.com> wrote in message
news:f378d05c-9b2a-4d6d-b338-0c978c71bd07@e23g2000prf.googlegroups.com...
>> "John Bartley K7AAY" wrote:
>> > In Excel 2003,
>> >
>> > mpeg2_MP@H1440_1280x720p_29.97fps_CBR_40Mbs_openGOP_zzscan.mpv
>> > comes before
>> > mpeg2_MP@H1440_720x576i_25fps_CBR_45Mbs_closedGOP_alternatescan_LFF.mpv
>> >
>> > In XP's Windows Explorer and also using DIR/ON in a command prompt
>> > shell window, the sort order is reversed.
>> >
>> > How do I reconcile the two so they sort in the same order?
>> >
>> > Thank you kindly.
>
>
>
> On Mar 13, 2:35 pm, sgopus <sgopus@discussions.microsoft.com> wrote:
>> Try this group instead
>> http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?query=sort+order&cboDiscussionGroup=en_US_34a4dcef-6aac-414e-9881-2ba33de8be2f%3Amicrosoft.public.excel.misc%3Aen%3AUS%3A%3A%3A%3A&=Go&dg=microsoft.public.excel.misc&cat=en_US_34a4dcef-6aac-414e-9881-2ba33de8be2f&lang=en&cr=US&pt=&catlist=&dglist=&ptlist=&exp=&sloc=en-us
>
>
> It requires me to create an MSN Hotmail, MSN Messenger, or Passport
> account. I have a surfeit of web accounts to memorize, and I think the
> answer would be of benefit to the members of this USENET newsgroup
> instead of shut up behind a walled garden, owned by M$.

Try this link.
news://msnews.microsoft.com/microsoft.public.excel.misc

--
Frank Saunders MS-MVP IE,OE/WM
www.fjsmjs.com
Do not reply with email