a) You write "1/2" and Excel replaces it with "01. Feb" by default if using de-DE as Locale (just checked it) [This auto replacement is also the basis of the linked article]
b) There is no "." on the num-pad for German keyboard layouts, they have a "," the German decimal separator.
Damn, you‘re right about the comma on German num blocks. I’ve avoided anything but US Keyboards for over a decade. Local keyboards are just another pain, like OS wide locals.
b) There is no "." on the num-pad for German keyboard layouts, they have a "," the German decimal separator.