When a cell date format is set to yyyy-mm-dd, the input line will show US format
mm/dd/yyyy. Also, when the cell is doubleclicked it also changes to US format
(from yyyy-mm-dd) until Enter is pressed.
To reproduce:
1. Open a new spreadsheet.
2. Format a cell A1 to Date in the format yyyy-mm-dd
- Highlight cell A1
- on the menu select "format->cells..."
- select Category: Date
Format : 1999-12-31 Language: Default
Note: The Format Code shows YYYY-MM-DD
3. In the cell enter date 2002-06-04; press "Enter"
4. Highlight the cell again
THE INPUT LINE SHOWS DATE AS: 06/04/2002
5. Doubleclick the cell
THE CELL SHOWS DATE AS: 06/04/2002
A. The cell should ALWAYS show the date in the format set for the cell.
B. The input line should ALWAYS show the date in the format set for the cell.
My OS is Windows 2000 US version.
The regional options are:
-General
- Your locale: English (United States)
-Date
- Short date format: yyyy-MM-dd
- Long date format: dddd, dd MMMM, yyyy (since yyyy-mm-dd, dddd is not available)
When a cell date format is set to yyyy-mm-dd, the input line will show US format
mm/dd/yyyy. Also, when the cell is doubleclicked it also changes to US format
(from yyyy-mm-dd) until Enter is pressed.
To reproduce:
Language: Default
1. Open a new spreadsheet.
2. Format a cell A1 to Date in the format yyyy-mm-dd
- Highlight cell A1
- on the menu select "format->cells..."
- select Category: Date
Format : 1999-12-31
Note: The Format Code shows YYYY-MM-DD
3. In the cell enter date 2002-06-04; press "Enter"
4. Highlight the cell again
THE INPUT LINE SHOWS DATE AS: 06/04/2002
5. Doubleclick the cell
THE CELL SHOWS DATE AS: 06/04/2002
A. The cell should ALWAYS show the date in the format set for the cell.
B. The input line should ALWAYS show the date in the format set for the cell.
My OS is Windows 2000 US version.
available)
The regional options are:
-General
- Your locale: English (United States)
-Date
- Short date format: yyyy-MM-dd
- Long date format: dddd, dd MMMM, yyyy (since yyyy-mm-dd, dddd is not