754

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

submitted 7 months ago by [email protected] to c/[email protected]

38 comments fedilink hide all child comments

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

[-] [email protected] 45 points 7 months ago* (last edited 7 months ago)

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 7 months ago

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 7 months ago

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 7 months ago

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

this post was submitted on 12 Feb 2024

754 points (98.5% liked)

Programmer Humor

32024 readers

508 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

[email protected]