On Mon, 11 Nov 2013 20:54:54 -0600
Denis Navas Vega <firstname.lastname@example.org> 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: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
- Re: [libreoffice-users] CALC convert text to numbers (continued)
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