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. 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. 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.
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
