El 2013-11-11 01:46 p.m., Paul escribió:
On Mon, 11 Nov 2013 11:30:11 -0600
Denis Navas Vega <email@example.com> 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: firstname.lastname@example.org
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 · Ady
Re: [libreoffice-users] CALC convert text to numbers · Oogie McGuire
[libreoffice-users] Re: CALC convert text to numbers · Denis Navas Vega
- FW: [libreoffice-users] Re: 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