Microsoft Fixes Excel Feature That Forced Scientists to Rename Human Genes::Microsoft now allows users to disable automatic date conversion, which means scientists no longer have to worry about using alternative names for genes.
Nowhere here is it implied that they were using it instead of a database. They could run into this issue whether or not they were properly using Excel for what it is for.
It’s a well known phenomenon. The title of the article even alludes to it.
I read this meme several times trying to figure out what is supposed to be funny about it… Then I realized it’s from Friends and based on a “joke” from that show. No wonder it wasn’t funny.
Edit: mmm yes, your downvotes only strengthen my resolve. Friends is shit and has always been shit. So unbelievably unfunny.
Microsoft fixed something and made their products better!? I don’t believe you.
I wonder if this will fix any of my issues with excel molesting my data. It will either round my part numbers from a BoM making it useless or removing preceding zeros which breaks our inventory importing.
I thought setting a column to string only was already possible.
It is, I’ve used that to prevent automatic removal of leading zeroes when reading the values of bytes.
Based on the article it seems like it’s just a matter of not having to spend the time (and mental overhead) of doing that for all required columns and never slipping up on it (now just set and forget).
What does excel and incels have in common? Confusing things for a date.
Omfg! The amount of time I screamed at Microsoft because I keep forgetting that excel changes the date format for some fucking reason and doesn’t tell you!