In OpenOffice Spreadsheet, how can I set the default Date format?
- by Joe Casadonte
I'm using OO 3.1.1 on Ubuntu 9.10 (in case that matters to the answer).
I like my dates to appear as YYYY-MM-DD. I can't think of a time when I want to see a date in any other format, so I'm constantly changing how dates look. That's manageable, though annoying. What's gotten me to the point of posting is that when I edit a cell with a date value, I have to edit it in the format MM/DD/YYYY, which is really, really annoying, as I'm usually mucking with the day (or possibly the month), and very seldom the year. So there's lots of cursor or mouse use, wasting my time.
So is there a way that I can change how dates are edited, or at least the default display format? Thanks!