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? Lee --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]