On Tue, 2006-01-10 at 10:44 -0700, Robin Laing wrote: > Steve Adam wrote: > > Hi, > > Congratulations on OpenOffice 2. > > > > Apparently dates, in spreadsheet cells > > *must* be entered in month/day/year order. > > > > As someone who has used day/month/year > > format all through my life, I find it very > > disconcerting to have to enter dates in > > another way. > > > > Steve. > > Once I format the cells for the date format that I prefer (ISO) I can > enter the dates as that format. I tried with DD/MM/YY and I could > enter dates that way. All you have to do is format the cells the way > you want. > > The only problem is you cannot set the default date to your prefered > date format. This has been raised before and I believe there is a RFE > on it.
Hi Robin, It depends on what locale (language setting) you have in OpenOffice.org. If you want to keep, say, US-English locale, but enter in dd/mm/yyyy format, you can alter the format of the cells as you mention above. If you want that as default, with the US locale, then you could always make a new default template with the formats you require. Regards Jonathon -- OOo Tips: http://mindmeld.cybersite.com.au/tips.rss OOo Knowledgebase: http://mindmeld.cybersite.com.au Training4Linux: http://www.training4linux.com Cybersite Consulting: http://www.cybersite.com.au --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
