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 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
