News for hackers. Stuff that matters.

A comment on Scientists rename human genes to stop MS Excel from misreading them as dates. Parent comment

Re:Scientists rename human genes to stop MS Excel from misre... by pintxo on Thursday August 06, 2020 @04:03PM (#24074867)
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.

[ Parent | on HN ]
Re:Scientists rename human genes to stop MS Excel from misre... by FrojoS on Friday August 07, 2020 @07:24PM (#24087445)
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.
[ Parent | on HN ]
Re:Scientists rename human genes to stop MS Excel from misre... by stjohnswarts on Thursday August 06, 2020 @04:40PM (#24075236)
If you write 1/2 just put a ' in front of it.
[ Parent | on HN ]
Re:Scientists rename human genes to stop MS Excel from misre... by pintxo on Thursday August 06, 2020 @05:50PM (#24075841)
Not if I want it to be converted to a date ;-)
[ Parent | on HN ]