I want to create an Excel-Sheet that the whole bureau will use.
Among other things we set two dates (DD/MM/YY).
Some colleagues enter “ddmmyy”, some others enter “ddmmyyyy” and some enter “dd.mm.yy” or even “dd.mm.yyyy”.
I want Excel to recognize every case and set the date to “dd.mm.yy”.
But I want to calculate with the date after entering, so it must be a date-format and not a string.

I tried it with Format Cell and set “TT”.”MM”.”JJ;@” (it’s German). But when I enter 260724, it is changed to 01.11.13.

How can I achieve that?