[users] Re: How to change the date/time format to 2006/07/09 23:55:55

2009-04-05 Thread Eustace
On 2009-03-30 12:06 S P Arif Sahari Wibowo wrote: On Sat, 29 Nov 2008, S P Arif Sahari Wibowo wrote: 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, Just a note:

[users] Re: How to change the date/time format to 2006/07/09 23:55:55

2009-03-30 Thread S P Arif Sahari Wibowo
On Sat, 29 Nov 2008, S P Arif Sahari Wibowo wrote: 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, Just a note: I found that the locale setting "English (South Af

Re: [users] Re: How to change the date/time format to 2006/07/09 23:55:55

2008-11-30 Thread Andis
Hi! When necessary cells selected press Format -> Cells... -> Numbers, then select Date (or anything else) and in 'Format code' write something like /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

[users] Re: How to change the date/time format to 2006/07/09 23:55:55

2008-11-29 Thread S P Arif Sahari Wibowo
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? Than