If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sorting Differences (Ex07 vs. Ex07(Compatibility Mode)/Ex03), HELP
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 |
#2
|
|||
|
|||
Sorting Differences (Ex07 vs. Ex07(Compatibility Mode)/Ex03),HELP
|
#3
|
|||
|
|||
Sorting Differences (Ex07 vs. Ex07(Compatibility Mode)/Ex03),
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 . |
Thread Tools | |
Display Modes | |
|
|