On 17/01/2008, Johnny Rosenberg <[EMAIL PROTECTED]> wrote: > 2008/1/16, Dotan Cohen <[EMAIL PROTECTED]>: > > > > I have a Calc document (created in Calc as ods) with a date column. In > > Format Cells -> Numbers -> Category -> Date -> Format I have set > > 1999-12-31. When I enter dates (only in that format) they display > > fine. However, if I select a cell and choose "default formatting" then > > the cell displays a number. For instance, for the date 2008-16-01 I > > choose default formating and it turns into 39463. > > > Are you sure you don't mean 2008-01-16? I don't think YYYY-DD-MM is an > existing date format, is it? YYYY-MM-DD however, is a part of the > international standard date format ISO 8601.
I _do_ mean 2008-01-16. Silly me. Dotan Cohen http://what-is-what.com http://gibberish.co.il א-ב-ג-ד-ה-ו-ז-ח-ט-י-ך-כ-ל-ם-מ-ן-נ-ס-ע-ף-פ-ץ-צ-ק-ר-ש-ת A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing?
