4 ms·
> Scientists rename genes to stop Microsoft Excel from misreading them as dates I thought they fixed that bug. Oh wait, this is Microsoft. /s
by hulitu 3y ago
> Scientists rename genes to stop Microsoft Excel from misreading them as dates
I thought they fixed that bug. Oh wait, this is Microsoft. /s
- makeitdouble 3y agoAt this point there must be enough people in the world relying on that behavior that you can't just change it. Perhaps having an option somewhere could be done, but it would sit there among the hundreds of other options that so many people have no idea about. I think changing Excel's default behavior is a social challenge in itself, I'd be having a stomach ulcer for decades if I was Excel's prooduct manager.
- chrisjj 3y agoI've seen no evidence this is a bug.
- hulitu 3y ago> I've seen no evidence this is a bug. Maybe it depends on your use case, but why it converts almost everything to dates ? Why not to numbers ?
- reportgunner 3y agoDates are stored as numbers in Excel. Excel also tries to automatically convert numbers as well.
- mnau 3y agoUsers enter text. That's how it always has been, because they use keyboard. If format is set to General, Excel tries to make the best guess what is inputted and convert it to that value, so things like SUM work. That is very sensible behavior. Your accountant doesn't want to set format and only then enter number. She has a job to do, so just do it for her. Same thing for dates. This guessing algorithm has some edge behavior, but always happens. C# DateTime.TryParse("DEC12") will deduce date is 2012-12-01. Yay? Do you want to keep it as text? Add ' as a first character (it's not considered a part of the string) or format cells to non-General format (e.g. Text) before entering a text.
- chrisjj 3y agoA use case that excludes understanding this feature does not make the feature a bug.