Programmer Humor

32495 readers

472 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

AgreeableLandscape@lemmy.ml

cat_programmer@lemmy.ml

762

when you import some data into Excel and it tries to format all your number fields (lemmy.world)

submitted 9 months ago by Agent641@lemmy.world to c/programmerhumor@lemmy.ml

38 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[–] festus@lemmy.ca 44 points 9 months ago* (last edited 9 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

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

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

[–] flambonkscious@sh.itjust.works 1 points 9 months ago

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