747
this post was submitted on 12 Feb 2024
747 points (98.3% liked)
Programmer Humor
32371 readers
295 users here now
Post funny things about programming here! (Or just rant about your favourite programming language.)
Rules:
- Posts must be relevant to programming, programmers, or computer science.
- No NSFW content.
- Jokes must be in good taste. No hate speech, bigotry, etc.
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Fuck you Excel, that’s a date, not $946,684,800
Honestly, the automatic datetime conversion 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 that off. 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)!
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.