El 2013-11-11 01:46 p.m., Paul escribió:
On Mon, 11 Nov 2013 11:30:11 -0600
Denis Navas Vega <[email protected]> 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
number.
Paul
Paul,
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: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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
