Gifted Minecraft
  • Communities
  • Create Post
  • Create Community
  • heart
    Support Lemmy
  • search
    Search
  • Login
  • Sign Up
Agent641@lemmy.world to Programmer Humor@lemmy.ml · 1 year ago

when you import some data into Excel and it tries to format all your number fields

lemmy.world

message-square
31
fedilink
764

when you import some data into Excel and it tries to format all your number fields

lemmy.world

Agent641@lemmy.world to Programmer Humor@lemmy.ml · 1 year ago
message-square
31
fedilink
alert-triangle
You must log in or register to comment.
  • TherouxSonfeir@lemm.ee
    link
    fedilink
    arrow-up
    70
    ·
    1 year ago

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

    • deweydecibel@lemmy.world
      link
      fedilink
      English
      arrow-up
      56
      ·
      edit-2
      1 year ago

      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
        link
        fedilink
        arrow-up
        25
        ·
        edit-2
        1 year ago

        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.worldOP
          link
          fedilink
          arrow-up
          14
          ·
          1 year 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
          link
          fedilink
          arrow-up
          3
          ·
          1 year ago

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

          • Micromot@feddit.de
            link
            fedilink
            arrow-up
            2
            ·
            1 year ago

            Or use Ohook

            • TherouxSonfeir@lemm.ee
              link
              fedilink
              arrow-up
              3
              ·
              1 year ago

              Who hook?

              • Micromot@feddit.de
                link
                fedilink
                arrow-up
                4
                ·
                1 year ago

                The office activation method from massgrave.dev

      • biscuitswalrus@aussie.zone
        cake
        link
        fedilink
        arrow-up
        12
        ·
        1 year ago

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

  • festus@lemmy.ca
    link
    fedilink
    English
    arrow-up
    45
    ·
    edit-2
    1 year 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

    • flambonkscious@sh.itjust.works
      link
      fedilink
      English
      arrow-up
      18
      ·
      1 year 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…

      • festus@lemmy.ca
        link
        fedilink
        English
        arrow-up
        6
        ·
        1 year 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.

        • flambonkscious@sh.itjust.works
          link
          fedilink
          English
          arrow-up
          1
          ·
          1 year ago

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

  • danc4498@lemmy.world
    link
    fedilink
    English
    arrow-up
    30
    ·
    1 year ago

    CSV files having their leading zeros cut off fuck my entire world up.

    • wizardbeard@lemmy.dbzer0.com
      link
      fedilink
      English
      arrow-up
      1
      ·
      1 year ago

      Instead of just opening them with Excel, make a blank workbook or sheet, go to the data tab, import from text/csv. It’ll give you a bunch of menus and such where you can adnust how it reads the file and how it will format columns. Any column with leading zeros you want as text. It doesn’t fuck with “as text” columns.

      The only caveat is that once you’ve imported the CSV that way, you’ll want to open the data sources tab and delete the connection to the csv file, otherwise changes in the original csv file will change shit in your spreadsheet, but only if excel feels like syncing it. Better to shut that off and do it yourself as needed.

    • christophski@feddit.uk
      link
      fedilink
      English
      arrow-up
      1
      ·
      1 year ago

      Dealing with phone numbers and people using excel…

  • potentiallynotfelix@lemmy.ml
    link
    fedilink
    arrow-up
    33
    arrow-down
    3
    ·
    1 year ago

    libreoffice reigns supreme

  • katy ✨@lemmy.blahaj.zone
    link
    fedilink
    arrow-up
    23
    ·
    1 year ago

    can you imagine a world without excel?

  • Blackmist@feddit.uk
    link
    fedilink
    English
    arrow-up
    20
    ·
    1 year ago

    Nice barcode you have there. Be a shame if somebody took any leading zeroes off.

    Nice Int64 you have there. Be a shame if somebody rounded it to 14 significant digits.

    • wizardbeard@lemmy.dbzer0.com
      link
      fedilink
      English
      arrow-up
      3
      ·
      edit-2
      1 year ago

      Import from the data tab, force all columns as text formatting. Excel won’t fuck with the formatting then.

  • 𝘋𝘪𝘳𝘬@lemmy.ml
    link
    fedilink
    arrow-up
    7
    ·
    1 year ago

    #VALUE!

  • Dave@lemmy.nz
    link
    fedilink
    arrow-up
    7
    ·
    1 year ago

    But treats a random half of your numbers as text

    • Rookwood@lemmy.world
      link
      fedilink
      arrow-up
      4
      ·
      1 year ago

      That’s a good thing.

  • quicken@aussie.zone
    cake
    link
    fedilink
    arrow-up
    7
    ·
    1 year ago

    Like how several Genes were renamed because of excel https://www.theverge.com/2020/8/6/21355674/human-genes-rename-microsoft-excel-misreading-dates

  • ZoopZeZoop@lemmy.world
    link
    fedilink
    arrow-up
    6
    ·
    1 year ago

    Alt+h+v+v

    • xpinchx@lemmy.world
      link
      fedilink
      arrow-up
      5
      ·
      1 year ago

      Unrelated but alt+e+s+v is so ingrained into my muscle memory. I should really get a macro pad

    • droans@lemmy.world
      link
      fedilink
      arrow-up
      4
      ·
      1 year ago

      Ctrl+Shift+V exists now which does the exact same thing.

      Actually it’s a bit better. Excel always ignores alt codes for the first key press or two after switching windows.

  • expr@programming.dev
    link
    fedilink
    arrow-up
    4
    ·
    1 year ago

    https://www.visidata.org/ > excel for manipulation and navigation of data.

  • jevans ⁂@lemmy.ml
    link
    fedilink
    arrow-up
    3
    ·
    1 year ago

    laughs in pola.rs

  • Parabola@lemmy.world
    link
    fedilink
    arrow-up
    3
    arrow-down
    9
    ·
    1 year ago

    “Programmer humor” “excel”

    • Agent641@lemmy.worldOP
      link
      fedilink
      arrow-up
      4
      ·
      1 year ago

      Programmers who have to deal with data I/O and SQL regularly need to use a spreadsheet to examine, columnize and validate data manually, so that data structures are confirmed to be correct. Nobodys programming in Excel per se, but its still a ubiquitous tool that we use on the regular.

Programmer Humor@lemmy.ml

programmerhumor@lemmy.ml

Subscribe from Remote Instance

Create a post
You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: !programmerhumor@lemmy.ml

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.
Visibility: Public
globe

This community can be federated to other instances and be posted/commented in by their users.

  • 99 users / day
  • 1.03K users / week
  • 3.18K users / month
  • 9.97K users / 6 months
  • 1 local subscriber
  • 36.9K subscribers
  • 1.61K Posts
  • 26.4K Comments
  • Modlog
  • mods:
  • AgreeableLandscape@lemmy.ml
  • cat_programmer@lemmy.ml
  • BE: 0.19.9
  • Modlog
  • Legal
  • Instances
  • Docs
  • Code
  • join-lemmy.org