Mysterious ' in Calc - WITH ATTACHMENT

[David Deeks <pr...@gmail.com>]

Sorry, forgot attachment, here it is ….

> On 27 Jun 2021, at 22:49, David Deeks <pr...@gmail.com> wrote:
> 
> Hi there all you helpful people!
> 
> Can’t believe how much I’ve learned since ‘joining’ you lot (!), but am stuck with this one.
> 
> 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 body of the spreadsheet and in the ‘format’ window without it. I have extracted all the rogue ones into a separate spreadsheet in order to fiddle with them but have so far tried all different formats available without success.
> 
> See attached screenshot from my MacBook showing one of the fields highlighted, and how it appears in the ‘input line’ and cell format window.
> 
> Can anyone help get rid of the rogue ‘ ?
> 
> Thanks!
> 
> David Deeks