At 10:13 06/04/2022 +1200, Steve Edmonds wrote:
...just wondering if there is an easy way to clear formatting of the
style '2892 where the apostrophe is used. When I paste data from a
web page LO inserts the apostrophe by default. I realise there are
options on pasting to have numbers pasted as text, but my query is
in regards converting '2892 to the number 2892.
Are we talking spreadsheets? I don't think you mean formatting at
all. At least, I suspect those apostrophes do not appear in the
spreadsheet cells but instead only in the Input Line when you select
a relevant cell. The apostrophe is just an indication - a warning -
that what looks like a number in the cell is actually text. (Another
indication may be that the values are left- rather than right-aligned
I cannot Format Cells... format as number or clear direct formatting ...
Well, you can do all of those things, but none of them will change
the values you have in the cells, which is what you need to do - to
convert text to the numerical value of that text, to convert
two-eight-nine-two to two thousand, eight hundred and ninety-two.
... or find and replace the '.
You certainly cannot do that, as there is no apostrophe in the cell
value to be found!
Here's an easy way:
o Select the column of values.
o Go to Data | Text to Columns... .
I trust this helps.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy