this post was submitted on 12 Feb 2024
763 points (98.4% liked)

Programmer Humor

32588 readers
1577 users here now

Post funny things about programming here! (Or just rant about your favourite programming language.)

Rules:

founded 5 years ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[–] tsonfeir@lemm.ee 70 points 9 months ago (1 children)

Fuck you Excel, that’s a date, not $946,684,800

[–] deweydecibel@lemmy.world 56 points 9 months ago* (last edited 8 months ago) (2 children)

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.

[–] Identity3000@lemmy.world 25 points 9 months ago* (last edited 9 months ago) (2 children)

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)!

[–] Agent641@lemmy.world 14 points 9 months ago

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.

[–] 30p87@feddit.de 3 points 9 months ago (1 children)

Also means one has to give up the license they bought years ago for Office 2019 and actually pay monthly now.

[–] Micromot@feddit.de 2 points 9 months ago (1 children)
[–] tsonfeir@lemm.ee 3 points 9 months ago (1 children)
[–] Micromot@feddit.de 4 points 9 months ago

The office activation method from massgrave.dev

[–] biscuitswalrus@aussie.zone 12 points 9 months ago

It should make me irrationally angry, but no, it's a rational hatred. It burns even more intensely.