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+unsubscr...@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