Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John Bartley K7AAY - 13 Mar 2008 21:36 GMT
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 - 13 Mar 2008 22:35 GMT
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


> In Excel 2003,
>
[quoted text clipped - 8 lines]
>
> Thank you kindly.
John Bartley K7AAY - 14 Mar 2008 01:38 GMT
> > In Excel 2003,
> >
[quoted text clipped - 8 lines]
> >
> > Thank you kindly.

> Try this group instead
> http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?query=sort+or
der&cboDiscussionGroup=en_US_34a4dcef-6aac-414e-9881-2ba33de8be2f%3Amicrosoft.pu
blic.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=&ptlis
t=&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$.
Bob I - 14 Mar 2008 13:56 GMT
>>>In Excel 2003,
>>>
[quoted text clipped - 16 lines]
> 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.
Frank Saunders MS-MVP IE,OE/WM - 15 Mar 2008 13:32 GMT
>> > In Excel 2003,
>> >
[quoted text clipped - 16 lines]
> 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

Signature

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

Ben Lucas - 14 Mar 2008 05:20 GMT
> 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.
K7AAY - 14 Mar 2008 16:26 GMT
> > In Excel 2003,
> > mpeg2_MP@H1440_1
[quoted text clipped - 6 lines]
> 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 Lucas - 15 Mar 2008 01:18 GMT
>> > In Excel 2003,
>> > mpeg2_MP@H1440_1
[quoted text clipped - 14 lines]
>
> Many thanks to Ben Lucas for pointing the way to the solution!

I'm gald you got it fixed!

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.