Hi David,
On Sun, Mar 05, 2006 at 14:05:53 -0500, David A. Wheeler wrote:
> Yet another alternative is to try to accept both "," and "." as
> decimal points. That risks ambiguity unless you FORBID
> thousands separators, and I don't think anyone DOES it
> (suggesting it's not actually that useful). I don't actually think
> that'd be a good idea, but it's worth mentioning for completeness.
Ok, you mentioned it, now let's forget it ;-)
> > > How do you make that locale independent?
> > > We will have similar problems with dates.
>
> Not necessarily; you can declare than YYYY-MM-DD is always
> ISO 8601 format.
You're quoting without context. That was a user's formula, something
like =a1&"."&a2, where declaring some YMD order being ISO doesn't help
anything.
> For those who use other calendars, a standard prefix can
> be used; I believe that's also common for those who use other
> calendars. Having the "unprefixed" calendar be an ISO standard
> should be easy to justify.
Sorry, but what are you talking about? Standard prefix where? In what
context?
Eike