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.
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?
