On Mon, 2006-07-10 at 06:54 -0400, Lee Wiggers wrote: > On Sun, 9 Jul 2006 12:32:53 -0700 (PDT) > Jeff Sherk - Kingdom Alarms <[EMAIL PROTECTED]> > wrote: > > > > I need to change the default date format to 2006/07/09 and the > > > time format to 24 hour 23:55:55. > > > > If you need to do it in a spreadsheet in Calc, do the following: > > > > Select the cells where you want to change the format. > > > > Choose FORMAT then CELLS then click the NUMBERS Tab. > > > > Choose User-defined in the Category box. > > > > Then down in the Format Code box, put the following: > > yyyy/mm/dd hh:mm:ss > > > > This format will now be available the next time you need to use it > > (you won't have to type anything in the Format Code box. > > > > I don't think you can make it the default format for Dates though (if > > you can, I don't know how to do it). Whenever you enter a Date, you > > will have to go to FORMAT->CELLS and choose your pre-defined format. > > > > > > > This format is becoming increasingly popular. I know > that my firm would benefit from being able to convert > dd/mm/yy or mm/dd/yy to yy/mm/dd, which we use to tag > filenames. > > How does one suggest the feature be added? >
There are a number of open issues on this subject. One is http://qa.openoffice.org/issues/show_bug.cgi?id=3093 The problem seems to be locale settings taking precedence over what is wanted. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/
smime.p7s
Description: S/MIME cryptographic signature
