3 ms·
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 li
by pintxo 6y ago
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.
- stjohnswarts 6y agoIf you write 1/2 just put a ' in front of it.
- pintxo 6y agoNot if I want it to be converted to a date ;-)
- FrojoS 6y agoDamn, 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.