2009/11/15 James R. Liebert <[email protected]>: > Users may set a Windows system to YYYY-MM-DD. All applications > depending on the default system date format then will so display. > > At Calc _T_ools menu: _O_ptions: OpenOffice.org Calc: Calculate, OO > users may set default Date format to one of three format variants, which > exclude YYYY-MM-DD.
Have you actually looked at that place yourself? It's NOT about date format. It only sets which date is day 0 (default is 1899-12-30 - 30 dec 1899 that is). This is probably for compensating for the date bug in Excel. Excel thinks that the year 1900 is a leap year, but OpenOffice.org knows it's not. So to make things work anyway, day 0 in Excel i 1899-12-31 and in Calc it is 1899-12-30. This means that dates before 1900-03-01 a dasplayed wrong in Excel and correctly in Calc. Dates from 1900-03-01 and later are displayed correctly in Excel and in Calc. > > OO users may format particular Calc cells YYYY-MM-DD by so entering into > the _F_ormat code field at F_o_rmat menu: Numbers tab: _C_ategory: Date. That's what he did, I think. However I think that was described in another thread. > > OO Writers may _I_nsert: Fields: Other, where they may specify format of > individual dates to be inserted. > > If these simple options are of no avail, write back. > > JRL > > Dotan Cohen wrote: >> 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? >> >> Thanks. >> >> > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
