Thanks very much for your explanation re the Text to Columns facility Brian.
To answer your question …
For many years I have done reviews for a music magazine and the values are
quality ratings (1-5 ’stars’) for vinyl records and cds - three columns
denoting Music Quality, Sound Quality, and (f
At 15:35 28/06/2021 +0100, David Deeks wrote:
Thanks for this Brian - feeling suitably
admonished here for not being specific enough
particularly as I spent my working life designing computer business systems!
Oh, I was not trying to be critical.
I don't require them to be numbers per se
Thanks for this Brian - feeling suitably admonished here for not being specific
enough – particularly as I spent my working life designing computer business
systems!
I don’t require them to be numbers per se – as explained in my first email I
need to be able to sort them, but should have made i
At 11:30 28/06/2021 +0100, David Deeks wrote:
Thanks very much Brian - almost completely sorted!
I have a few exceptions where the contents of the field are not
simple numbers. They indicate a small range thus e.g. 2-3, 3-4, or
an either/or thus e.g. 2/3, 3/4.
In both cases they show the cor
At 17:22 27/06/2021 -0700, Chuck Spalding wrote:
On Sun, Jun 27, 2021 at 3:46 PM Brian Barker wrote:
At 22:49 27/06/2021 +0100, David Deeks wrote:
I have discovered that I have some part-columns of figures in Calc
that do not sort properly, and have identified that, unlike other
numbers in the
Thanks for the very fast response Rory(!), but I already realised this and
‘Text’ is one of the formats I tried, with the same result? I am also mystified
as to why it always shows the correct result in the ‘text to columns’ overlay
screen, but not in the spreadsheet cells?
David
> On 28 Jun 2
On Mon, 28 Jun 2021 11:30:28 +0100
David Deeks wrote:
> Thanks very much Brian - almost completely sorted!
>
> I have a few exceptions where the contents of the field are not simple
> numbers. They indicate a small range thus e.g. 2-3, 3-4, or an either/or thus
> e.g. 2/3, 3/4.
>
> In both ca
Thanks very much Brian - almost completely sorted!
I have a few exceptions where the contents of the field are not simple numbers.
They indicate a small range thus e.g. 2-3, 3-4, or an either/or thus e.g. 2/3,
3/4.
In both cases they show the correct result 2-3 or 2/3 in the text to columns
ov
Brian,
Thank you for enlightening us to this useful information! I'm sure there
are many other features of OpenOffice that I haven't yet "discovered".
Chuck
On Sun, Jun 27, 2021 at 3:46 PM Brian Barker
wrote:
> At 22:49 27/06/2021 +0100, David Deeks wrote:
> >I have discovered that I have some
At 22:49 27/06/2021 +0100, David Deeks wrote:
I have discovered that I have some part-columns of figures in Calc
that do not sort properly, and have identified that, unlike other
numbers in the same columns, they all appear in the "input line"
with a ' preceding them - whilst appearing in the b
10 matches
Mail list logo
