How to get calc to recognize pasted input as date, not text?

[ThomasK]

I’d like to enter dates formatted “TT.MM.JJJJ” into libre office calc.

Inserting a single date works. two dates seperated by a tabulator (so 1 row, 2 columns) works fine to.
But as soon as I try to insert multiple rows I get this nice open csv wizard view and no matter what options I choose in there my dates are recognized as text instead of date.

Please help. I’m working on Linux Mint 18 (~ Ubuntu 16.04) which comes with:

Libre Office Version: 5.1.3.2 Build
ID: 1:5.1.3-0ubuntu1 CPU Threads: 8;
OS Version: Linux 4.4; UI Render:
default;  Locale: en-US (en_US.UTF-8)

[ThomasK]

Hah! I thought I tried that before, but this time it worked:

1. select language “German (Austria)” and
2. check “detect special numbers”