Honestly, the date conversation is the worst part if you’re just trying to keep it text. It’s idiotic there isn’t a simple way to turn off the automatic datetime conversion. That’s not formatting, that’s actually changing the data in those cells which may not be what you want.
In case you’re not aware, the latest version of Excel absolutely DOES have that setting (mentioned elsewhere here in the comments). While it’s wild that it took so long, it’s now a solvable problem and everyone should know about it (and upgrade)!
Honestly, the date conversation is the worst part if you’re just trying to keep it text. It’s idiotic there isn’t a simple way to turn off the automatic datetime conversion. That’s not formatting, that’s actually changing the data in those cells which may not be what you want.
It should make me irrationally angry, but no, it’s a rational hatred. It burns even more intensely.
In case you’re not aware, the latest version of Excel absolutely DOES have that setting (mentioned elsewhere here in the comments). While it’s wild that it took so long, it’s now a solvable problem and everyone should know about it (and upgrade)!
It should be, and should always have been defaulting to the “dont fuck about with my data” setting.
Because there really aren’t too many scenarios where I want my barcodes abbreviated to scientific notation.
Also means one has to give up the license they bought years ago for Office 2019 and actually pay monthly now.
Or use Ohook
Who hook?
The office activation method from massgrave.dev