At 12:34 11/12/2014 -0500, Helen Etters wrote:
How can I tell LO spreadsheet that in this particular cell, I want
to write "January 2014" and that's what I want it to say- don't
change it to date format, just leave that text.
Simplest: format the cell as Text *before* entering the data.
Alternatively, either
(1) precede the required text by an apostrophe (plain, not smart), to
prevent the automatic detection of a date, or else
(2) enter ="January 2014".
I trust this helps.
Brian Barker
--
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
