Wheezy: Changing date format in LibreOffice Calc

[Ldten K <ldtenk@yahoo.com>]

Hi,

I am trying to change a date format in LibreOffice Calc (LOC). I thought it would be a simple thing to do but for some reason it doesn't work for me. What I did:

1. Open LOC, start a new spreadsheet
2. Enter 6 new rows in column A as follows:
   20.11.2013
   21.11.2013
   22.11.2013
   23.11.2013
   24.11.2013
   25.11.2013
3. Clear any existing formatting to be sure: select column A, Menu > Format > Clear Direct Formatting
4. Apply MM/DD/YYYY formatting: select column A, Menu > Format > Cells > Date > MM/DD/YYYY > OK

The above steps result in no change for me, the dates are still shown as DD.MM.YYYY, no warning or error message is given.

Any ideas? Thanks