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. Note that before the conversion, when selecting a cell with a date, > although the cell displays 2008-16-01 the edit bar at the top of the > app displays 16/01/2008. After the default formatting, both the cell > and the edit bar show 39463. > > Now, the questions: > 1) How do I get OOo to display the date as I've configured it to, even > after applying default formating to a cell? > 2) How do I get OOo to display the date as I've configured it to in > the edit bar as well as the cell? > > Thanks in advance. > > 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? >
