Excel is not "complete" until they stop forcibly converting long strings of numbers into scientific notation - or at least give me a sheet-specific way to turn it off. I know how to stop it on my machine, but I have shared documents where if any one of the 16+ other users forgets, then it's messed up for everyone.

Let alone the date issues.

At one point I did a deep dive on one or the other of these "quirks", and the earliest request for exactly the fix I want is from nineteen-eighty-fricking-five. Unbelievable.

Yes, there will be edge cases. They need to balance historic compat vs one more fricking setting checkbox. I am thinking that you will never see this solved.