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

Am 15.11.2013 12:06, schrieb Brian Barker:

> Type
> '1234 into a cell, so that you get the four-character text string
> 1234 in the cell (not the five-character string '1234).

I you do this, the content of the cell will be '1234 and the cell
will display the text 1234 as a result.

>  Now put
> =LEFT(Xn;1) in another cell - to extract just the first character. 
> According to your theory, this formula should evaluate to just the
> apostrophe

No. According to what the programme does, you will get the character
1, because it is the first character of the result in cell Xn.

> But it's surely not an operator when it appears in the
> Input Line. 

Yes it is. Just like an = tells the programme that the following has
to be interpreted as a formula, the ' tells the programme that the
following has to be interpreted as text.

Stefan

-- 
LibreOffice - Die Freiheit nehm' ich mir!

-- 
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