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

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.
 
B

Ben Lucas

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.

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

Bob I

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$.

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.
 
K

K7AAY

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!
 
B

Ben Lucas

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!


I'm gald you got it fixed!
 
F

Frank Saunders MS-MVP IE,OE/WM

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$.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top