I am totally beside myself with this sorting challenge, perhaps one of my
peers out there has a workable solution for us.

BACKGROUND:
- We have several workbooks output from one of our databases with three key
fields (ALL are TEXT): Alpha Split; Age; and AcctNum.
- These workbooks have been generated for years without any changes to
these primary fields.
- The AGE field is a set of eight age ranges: 0-30; 31-60; 61-90; 91-120;
121-150; 151-180; 181-365; and 365+.
-- Under Ex03 and Ex07 (compatibility mode), when sorting on this field
it sorted properly (asending or descending) WITHOUT using any "custom lists".
- The only recent change was to change the output format from XLS (using
Ex07 Compatibility Mode) to XLSX.

PROBLEM:
1) With the workbook in XLSX format, the "Age" Field sorts as a true text
field (0-30; 121-150; 151-180; 181-365; 31-60; 365+; 61-90; and 91-120)
without using the "custom list".
a) Under normal circumstances this would not be a problem, but in our
corporate environment our IT has our C:\Program Files\Microsoft
Office\Office12\STARTUP folders locked down and they are NOT likely to change
anytime soon.

QUESTIONs:
1) Is our only choice (under our circumstances) to go back to the Ex07
Compatibility mode?
2) Or how can we get the sort my teams are used to and stay in Ex07?
3) How can we make a case for our IT team to open up that folder for our
staff to allow them to store custom lists?

Thank you in advance for your time and expertise.

--

MJ

Excel 2007
Sort as number.
A workaround.
http://www.mediafire.com/file/nyjwnm...10_26_09a.xlsx

Thank you for the input, I had already arrived at that work-around, thanks
again for your time and effort.

Was hoping someone could explain how come it sorts one way in Ex03/07
(Compatibility Mode) and entirely differently in Ex07, it is VERY PUZZLING!

Yes, I know we are talking about MS products... LOL

--

MJ


"Herbert Seidenberg" wrote:

Excel 2007
Sort as number.
A workaround.
http://www.mediafire.com/file/nyjwnm...10_26_09a.xlsx
.