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|1999-12-31 ? Or am I confusing Date formating with Text formating? In the latter case, the user should enter '2009-12-13 and then press Tab. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org