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

Programmer Humor

33490 readers
234 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
[–] festus@lemmy.ca 44 points 1 year ago* (last edited 1 year 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

[–] flambonkscious@sh.itjust.works 18 points 1 year 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...

[–] festus@lemmy.ca 6 points 1 year 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.

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