On Mon, 11 Nov 2013 20:54:54 -0600 Denis Navas Vega <[email protected]> wrote:
> Paul, > > Make this test. > > 1. Open a new worksheet. Format some cells, say from A5:A10 as text. > Write some numbers on those cells. Ok > 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, > E5=C5*1 Ok > 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 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
