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 <b.m.bar...@btinternet.com.invalid> 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 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. > [snip] > No need for that. There are various ways to repair values if what you > wanted was actually numbers. But here is a simple trick: > o Select the appropriate cells - possibly an entire column. (You can > include any genuine numbers without causing any problem.) > o Go to Data | Text to Columns... . > o Leave all options as default. > o OK. > > I trust this helps. > > Brian Barker >
