[libreoffice-users] Re: CALC convert text to numbers

El 2013-11-11 01:46 p.m., Paul escribió:
> On Mon, 11 Nov 2013 11:30:11 -0600
> Denis Navas Vega <denis.navas@gmail.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
> 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: users+unsubscribe@global.libreoffice.org
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