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

  • Thread starter Thread starter John Bartley K7AAY
  • Start date Start date
J

John Bartley K7AAY

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 Bartley K7AAY said:
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.
Click to expand...

Install TweakUI
http://windowsxp.mvps.org/tweakui.htm
Highlight Explorer, scroll down to "Use intuitive filename sorting"
Uncheck it and click OK.
 
John said:
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$.
Click to expand...

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.
 
Install TweakUIhttp://windowsxp.mvps.org/tweakui.htm
Highlight Explorer, scroll down to "Use intuitive filename sorting"
Uncheck it and click OK.
Click to expand...

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!
 
K7AAY said:
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!
Click to expand...


I'm gald you got it fixed!
 
John Bartley K7AAY said:
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$.
Click to expand...

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