Am 09.11.2010 15:17, Mike Scott wrote:
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.
Again the same trouble. Here we go again:
He should set his application locale to something like English(UK).
Currently it might be set to English(USA).
Tools>Options...LanguageSettings>Languages>Locale Setting
This affects the input method for all numbers and default formatting for
all table cells (incl. Writer), form controls, numeric Writer fields,
string conversion in Basic macros and the way how VALUE("1/2/99") works.
On cell/field/control level you may also set the number format locale to
something different than the default locale.
Greetings from Germany,
Andreas Säger
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
