this post was submitted on 12 Feb 2024
748 points (98.3% liked)

Programmer Humor

32710 readers
828 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
[–] [email protected] 44 points 11 months ago* (last edited 11 months ago) (1 children)

I'm not sure what version got this, but there's a setting now where you can disable auto-conversion and it's amazing.

https://mashable.com/article/microsoft-excel-disable-setting-auto-conversion-data-into-dates

[–] [email protected] 18 points 11 months ago (1 children)

Holy crap, that's amazing - I can't believe it would take this long! I presume straight up numbers are no longer affected, too, but I'm almost willing to trust it and try it out...

[–] [email protected] 6 points 11 months ago (1 children)

Yeah it stops converting numbers too. At my job we have a lot of ids that start with 0, and it was super annoying to have '000123' turn into '123', now it keeps it as text.

[–] [email protected] 1 points 11 months ago

That might just be the top tool of the week, then!