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]