You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openoffice.apache.org by 林思辰 <ca...@gmail.com> on 2013/03/10 10:13:44 UTC

question

ex.  2013.03.10 will become 13/3/10 automatically

how can I change that installation?

Re: question

Posted by Dave Barton <db...@tasit.net>.
-------- Original Message --------
From: ªL«äš° <ca...@gmail.com>
To: dev@openoffice.apache.org
Date: Sun, 10 Mar 2013 17:13:44 +0800
> ex.  2013.03.10 will become 13/3/10 automatically
>
> how can I change that installation?

Assuming you are referring to the displayed date formats in Calc cells:
    * Select/highlight the cell or range of cells to be formatted.
    * From the menu choose "Format -> Cells..."
    * In the dialog (window) that opens click the "Numbers" tab.
    * Under the "Category" list click "Date".
    * Replace the entry under "Format code" with YYYY.MM.DD
    * Click the tick/check mark (Add) button & click OK.

The default format that Calc uses internally cannot be changed and will
always appear that way in the "Formula Bar".

Please note: Support questions like this are best addressed to the
"users" list: users@openoffice.apache.org Additional support options and
resources can be found here: http://www.openoffice.org/support/






---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org