On 12/13/2009 03:51 PM, NoOp wrote: > On 12/13/2009 02:11 PM, Dotan Cohen wrote: >>>> Yes, but it is not the default locale in any but Hungarian and >>>> Latvian. I need it to be my default date format, so when an >>>> unformatted cell gets 2005-9-2 Calc doesn't mangle it into something >>>> else. >>>> >>> This can not work with "unformatted cells" (you mean number format >>> "General"). You are the one to format your cells or not. >>> 2005-9-2, 2.9.05 or the "true" value 37504 makes no difference at all. It is >>> really the same value. No formula result nor filter nor sort order depends >>> on the number format. >>> >> >> Let me state it another way: >> A user opens Calc and creates a new spreadsheet. He enters >> "2009-12-13" into cell A1. He expects that text to remain "2009-12-13" >> when he presses Tab. What must I configure beforehand to ensure that >> he gets what he expects? >> > > Anything preventing the user from: > Format|Cells|Date|C > ? > Or am I confusing Date formating with Text formating? > In the latter case, the user should enter > '2009-12-13 > and then press Tab.
Scratch the last: > '2009-12-13 > and then press Tab. I was testing with the cell still formated as a date. No need for the "'", just format the cell as text and enter 2009-12-13 as is. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
