Ok, this is driving me absolutely crazy. Any time I try to enter data in a cell with a format of, say, 7-8 (as in "7 to 8"), it keeps changing it to a date! How can I disable this permanently, forever, finito?
If I understand the question, DV88 wants to see the string "7-8" in the cell. That's easy, with 3.5.4:
a) Format cells where you want to see strings as "Text" before you start your inputs. b) If you only need that for 1 particular cell, start Input with single quote
In 3.6 the auto date recognition will be more restrictive, there (at least with my parallel installation of Master "LOdev 3.6.0alpha0+ – WIN7 Home Premium (64bit) ENGLISH UI [Build ID: 7175cee]" (tinderbox: Win-x86@6-fast, pull time 2012-05-16 22:07:37) "7-8" will not be recognized as date.
I think the easy way is to put a + or = at the beginning.
+7-8 or =7-8
1) Enter '7-8. This is same as Excel.
2) Before enter the string, set the data format as string in the range.
rightclick on the cell --> Cell format --> tab [Numbers] --> choose a preferred format!
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-05-19 04:21:05 +0200
Seen: 1,171 times
Last updated: May 21 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
