Date: prev next · Thread: first prev next last
2022 Archives by date, by thread · List index

=On 6 Apr 2022 at 10:13, Steve Edmonds wrote:

Date sent:60;Wed, 6 Apr 2022 10:13:51 +1200
To: 0;
From:  Steve Edmonds 
Subject: ;[libreoffice-users] Clearing formatting.

Hi, 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.</span>

Not sure this would work.
Assuming you are using text formatting dialog option.
You could click on the other option in addition to 
whatever filtering options you are using. Then put the 
apostrophe in the position after the other.
You will end up with a column with the blanks where the 
apostrophy was. Would then just delete that column.
That does assume that all numbers in column have 
apostrophy and that other cells don't have apostrophy's?
Another option that might work for you.
Past data as currently done.
In another column to right put formula
No leading &quot; an assuming D1 is cell with '2982 format 
numbers. Tried to match with "`" but it didn't work?? Had 
to use code and ascii value for `'
If all numbers have ` you could just use.
No leading &quot;

Then copy the formula going down.
Then highlight. Ctrl-C, and the Shift-Ctrl-V over original 
data, rather than doing one cell at a time.

Perhaps one of those would work with your data.
Good Luck. Have a nice day.

I cannot Format Cells... format as number or clear direct formatting or
find and replace the '. I can Ctl-x, Ctl-Shft-v and paste and the ' is


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:> Privacy Policy:

Michael D. Setzer II - Computer Science Instructor 
(Retired)                      &#160;
Guam - Where America's Day Begins                    &#160;
G4L Disk Imaging Project maintainer

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.