2009/11/14 Dotan Cohen <[email protected]>: > In both Writer tables and in Calc, when I enter a date in YYYY-MM-DD > format it gets reformatted as MM/DD/YY. My locale is set for the > YYYY-MM-DD format, and OOo is configured to use the default locale > settings. So where is this MM/DD/YY date coming from? How can I change > it on a global basis?
Not sure, but maybe you need to shange the language settings for your operating system. I think so because I currently use OpenOffice.org English (US) version and for me it's the other way around (which doesn't bother me since I always use the Swedish date format anyway, which is the same as the ISO-8601 format (YYYY-MM-DD). When I tried to change the format to your default format (MM/DD/YYYY) the input line of that cell displayed YYYY-MM-DD anyway. My operating system is Ubuntu 8.10 Swedish, so it seems to be an operating system thing here. I could temporary change my operating system to English and see what happens if you want to (it requires a logout - login), to verify that what I'm saying here is true… Johnny Rosenberg > > Thanks. > > -- > Dotan Cohen > > http://what-is-what.com > http://gibberish.co.il > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
