2009/12/13 Andreas Saeger <[email protected]>: > Dotan Cohen wrote: > >> >> Thanks, Andreas, but Hebrew support is far different than yyyy-mm-dd >> support! yyyy-mm-dd is not the default date format for Israel, rather, >> I think it is the British yy/mm/dd as you are familiar with. >> >> > > As far as I can see, ISO date yyyy-mm-dd is among the predefined date > formats in any locales.
Yes, but it is not the default locale in any but Hungarian and Latvian. I need it to be my default date format, so when an unformatted cell gets 2005-9-2 Calc doesn't mangle it into something else. > If not, you can add it as user defined date format. > Independent from the locale, all my spreadsheets use dates in this format > plus monospace font, so the dates are readable like decimals with proper > sequence of digits. > As far as I tried so far, any locale accepts yyyy-m-d as input format as > well. Under any locale you can type 3 integers with 2 dashes. If the input > gives some reasonable YMD-date, it will be a date in the locale's default > format or anything you may have applied before the entry. > > My default template contains a set of styles. Style "ISODate" (Default > number format locale) has a child style "ISODate+" (weekday appended), > another child style "ISODateTime" and one for time only. > I never care about the number format as long as I get the right values > (well, like you, I don't like reading US style MDY-dates). > Depending on the kind of document, I apply my prefered cell styles > beforehand or when I'm done. This has nothing to do with styles. > Quite often I used to debug other people's sheets. The first step is to > remove all formatting from all cells: Select all [Ctrl+A], double-click > style "Default", menu:Format>Default (remove hard attributes). Quite often > people are so obsessed with appearence that they forget about the validity > of their data. I find that hard to believe. If one applies the Default formatting to a date-formatted cell, the result is not a comprehensible date. -- Dotan Cohen http://what-is-what.com http://gibberish.co.il --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
