Re: [No longer] Mysterious ' in Calc

2021-06-29 Thread David Deeks
Thanks again Brian. I’ll change the columns to text as you suggest. The spreadsheet is saved as .ods. Perhaps as I think it originated as a .xls this explains the problem of rows reverting to wrong size. At some point, if ‘life’ doesn’t get in the way, I may have a go at re-building a .ods versi

Re: [No longer] Mysterious ' in Calc

2021-06-28 Thread Girvin Herr
On 6/28/21 4:55 PM, Dave Fisher wrote: Sent from my iPhone On Jun 28, 2021, at 4:45 PM, Girvin Herr wrote:  On 6/28/21 3:36 PM, Brian Barker wrote: At 22:55 28/06/2021 +0100, David Deeks wrote: Thanks very much for your explanation re the Text to Columns facility Brian. That's not my

Re: [No longer] Mysterious ' in Calc

2021-06-28 Thread Dave Fisher
Sent from my iPhone > On Jun 28, 2021, at 4:45 PM, Girvin Herr wrote: > >  >> On 6/28/21 3:36 PM, Brian Barker wrote: >> At 22:55 28/06/2021 +0100, David Deeks wrote: >>> Thanks very much for your explanation re the Text to Columns facility Brian. >> >> > >> That's not my experience or, I

Re: [No longer] Mysterious ' in Calc

2021-06-28 Thread Girvin Herr
On 6/28/21 3:36 PM, Brian Barker wrote: At 22:55 28/06/2021 +0100, David Deeks wrote: Thanks very much for your explanation re the Text to Columns facility Brian. That's not my experience or, I imagine, anyone else's. Brian et al., Your imagination is wrong. I have seen it. I just saw

Re: [No longer] Mysterious ' in Calc

2021-06-28 Thread Brian Barker
At 22:55 28/06/2021 +0100, David Deeks wrote: Thanks very much for your explanation re the Text to Columns facility Brian. No probs! 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 -