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 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]
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.
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".
In the interests of fairness, I ought to say that I'm pretty sure I
picked this trick up from someone on this list more knowledgeable or
experienced than me.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
