On Wednesday 16 January 2008 09:49:27 Dotan Cohen wrote:
> 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?
OOo stores the date as a number regardless of the date format you use. In
this case, 39463 is the number OOo associates with the date Jan 16, 2008. All
your date format does it to take the number and convert it to the desired
format.
1) Change the formating in the cell back to what you want it to be.
2) You don't. The date in the cell follows the date format you give it.
The date in the edit bar (Input line in English[USA]) follows the default
configuration for the language you are using. So, unless you find a language
which has a default date format of YYYY-DD-MM, the edit bar will not display
this format.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
