I still think it should be possible to set the language to "International". That would cause the date format to be set to YYYY-MM-DD by default since that is international standard (ISO 8601). If you want to solve your problem by just selecting a language that happens to have the same date format, I can recommend Swedish/Sweden or Swedish/Finland. I suppose there are many other options as well. However, you still have to select the long format for all the cells, since standard seems to be YY-MM-DD rather than YYYY-MM-DD.
Maybe creating a style with the proper settings is the best way after all. Or maybe a template with the style included. The template can of course open OpenOffice.org with a new document ready, based on the template, by just being double clicked, but I guess that's obvious. Johnny Andersson 2007/7/25, Adrian Try <[EMAIL PROTECTED]>:
Hi Jerry > I have an application that requires dates in yyyy-mm-dd format. I can > easily change the date format for individual cells, but is there a way > to globally tell calc to set the default date format to yyyy-mm-dd. The easiest way to do this would be to create a style with that particular date formatting. If you'd like more details, please ask. Adrian Try Another Angle www.tryanotherangle.org -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
