Hi Troy, it worked for me after I highlighted the "time" column right-clicked and unchecked "Number Recognition". I then right-clicked again and selected "Number Format" under the Category I then selected "Text" and clicked ok. When I sorted the table I made sure that it said Alphanumeric in the key type.
I ended up with this: 3:00 Concert Where 4:00 Concert Where 5 - 6:00 Concert Where 5:00 Concert Where 6:00 Concert Where 7:00 Concert Where Hope this helps! Shari On Fri, Mar 28, 2014 at 1:19 PM, <amazing_8...@rogers.com> wrote [snipped] : > > > The problem I have is when I try to sort numeric by column 1, the times > are messed up and not linear or ordered correctly.
