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

At 10:17 17/10/2016 -0400, Charles Marcus wrote:
On 10/15/2016 10:02 PM, Brian Barker wrote:
At 18:10 11/10/2016 +0100, Tom Davies wrote:
Can find&replace get rid of the ' marks to make the values revert to 'numbers/dates' rather than being forced into being text?


This claims otherwise:

Er, yes and no. I was replying, of course, to the suggestion that the apostrophes themselves could be searched for and replaced. They cannot, since they simply do not exist in the cell data. It's important that readers are not confused by the suggestion that they can.

But the web site offers a neat trick, if over-complicated by the presence of the circumflex, which unnecessarily locks the search to the beginning of the cell text. All that seems to be necessary is to search for "." and replace with "&". The process presumably relies on Calc's reinterpreting the values as it replaces them - now seeing them as numbers, just as it would if they were typed afresh.

In any case, Jean-Francois Nifenecker (who also answered "Nope" to the above suggestion) offered a technique using Data | Text to Columns... which was superior to my contribution.

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.