4 ms·
For trained programmers it might be more harm than help, but, for many laypeople, it absolutely is an advantage because it means Excel is automatically allowing
by munchbunny 4y ago
For trained programmers it might be more harm than help, but, for many laypeople, it absolutely is an advantage because it means Excel is automatically allowing them to handle date-like text as actual dates. Most of the time that's helpful.
- jhbadger 4y agoUnless you are a biologist. Excel is infamous for mangling names of genes and thinking they are dates. In fact some genes had to be renamed because it was considered easier to do that than get Microsoft to fix the problem (or you know, just not use Excel, which many non-programmer types, including many bench biologists, use as a general data holder, akin to an adhoc database) https://www.theverge.com/2020/8/6/21355674/human-genes-rename-microsoft-excel-misreading-dates https://www.theverge.com/2020/8/6/21355674/human-genes-renam...