Hi!

When necessary cells selected press Format -> Cells... -> Numbers, then select Date (or anything else) and in 'Format code' write something like YYYY/MM/DD and press green button (in my case) to add. It will now be available in User-defined number formats. Similar approach should be used in case of time, but the 'Format code' is HH:MM:SS. By the way, this is already available in the list of default number formats under Time.

Andis

S P Arif Sahari Wibowo wrote:
Hi!

On Sun, 9 Jul 2006, S P Arif Sahari Wibowo wrote:
I need to change the default date format to 2006/07/09 and the time format to 24 hour 23:55:55.

Well, after more thank 2 years, what is current state of OpenOffice.org ability in doing the date / time default format setup as above?

Thanks!


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to