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

El 2013-11-11 01:46 p.m., Paul escribió:
On Mon, 11 Nov 2013 11:30:11 -0600
Denis Navas Vega <> wrote:

The problem is with the symbol ' It can't be searched and replaced.
That's why Ady consider it a bug.

The only solution, which I used yesterday, is multiply by one.

I still don't understand what that is supposed to do. It sounds like a
kludge to me. The text string is a text string, I'm not sure why
anybody would think multiplying a text string by 1 would give you a



Make this test.

1. Open a new worksheet. Format some cells, say from A5:A10 as text. Write some numbers on those cells.

2. Copy those cells to other column, say to C5:C10 and format as number (format @). You will see that the cells now shows an ' before the numbers.

3. Write a formula in other cell, multiplying with 1, for instance, E5=C5*1

Now check the cell and you will discover that you have a number.

Therefore, those numbers with ', that in reallity are text, can be multiplied by 1, to transform it to a number.

As a side note, I was not able to use the method of copy -- paste multiplying by one.

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.