Re: [libreoffice-users] Re: sorting in calc

2017-03-10 Thread Gary Collins
willing to be proved wrong on that 😊) Again i think i'd be into the realm of macros! Thanks G. On Thu, 9/3/17, Brian Barker wrote: Subject: Re: [libreoffice-users] Re: sorting in calc To: users@global.libreoffice.org Cc: "Gary Colli

Re: [libreoffice-users] Re: sorting in calc

2017-03-09 Thread Brian Barker
At 18:59 08/03/2017 +, Gary Collins wrote: Is there a character i can enter into a cell that will come *before* numbers in the sort order? I mean, before other cells that actually contain numbers rather than numerical strings What about some value less than any of your real data are (or

[libreoffice-users] Re: sorting in calc

2017-03-09 Thread Pedro
Gary Collins wrote > Hello, > Is there a character i can enter into a cell that will come *before* > numbers in the sort order? > I mean, before other cells that actually contain numbers rather than > numerical strings Any character that shows up before zero in Character Map (if you are using Wind