On 09/11/10 14:06, Dotan Cohen wrote: > A user has a Calc spreadsheet in which the cells are configured for > this date format: > yyyy-mm-dd > He needs the cells to be displayed in this format, there is nothing to > argue about. > > He personally prefers to enter the data in this format: > dd-mm-yyyy > Even though he knows that it is backwards, this is his muscle memory. > However, Calc interprets this as mm-dd-yyyy. How can I configure Calc > to understand this as dd-mm-yyyy?
I've just tried this, out of curiosity. I set a cell to be formatted as yyyy-mm-dd. Whether I entered a date as 2001/5/4 or 4/5/2001 the result was the same, displayed as 2001-5-4. Same with dashes rather than slashes. Even 4/5/01 came out right. It only had trouble with 2001/May/4 :-) However, my locale is UK. Maybe that needs checking - if it's set to be US, then it might well interpret day and month on input the wrong way round. It would make some sort of sense. -- Mike Scott Harlow, Essex, England --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
