Copy to Troy Buckner who is not subscribed to this list. -------- Original Message -------- From: Shari Lynn Smith <webweave...@gmail.com> To: users@openoffice.apache.org Date: Fri, 28 Mar 2014 15:30:27 -0500
> 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. ------------------------------------------- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org