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

On Mon, 11 Nov 2013 20:54:54 -0600
Denis Navas Vega <> wrote:


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 @).
The '@' format is text, so I'm not sure what you want me to do, format
as text, or format as number?

You will see that the cells now shows an ' before the numbers.
Yes, if I format as number, this is correct.

3. Write a formula in other cell, multiplying with 1, for instance,

Now check the cell and you will discover that you have a number.
True enough, when I copy these cells, and paste special, pasting only
text and numbers, not formulas or all, then I get numbers in the cells.

Therefore, those numbers with ', that in reallity are text, can be 
multiplied by 1, to transform it to a number.
As Brain explained to me, an implicit VALUE() must be done on the text
when multiplying by 1.

As a side note, I was not able to use the method of copy -- paste 
multiplying by one.
How do you mean? When is the multiply done? If I copy the numbers from
the cells with the formulas it works fine.

So now I'm confused, if this *does* work, why was Ady complaining
about it not working?

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.