765
when you import some data into Excel and it tries to format all your number fields (lemmy.world)
submitted 2 years ago by to c/programmerhumor@lemmy.ml
37 comments fedilink hide all child comments
 
you are viewing a single comment's thread
view the rest of the comments
[–] 70 points 2 years ago (1 child)

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

  • permalink
  • fedilink
  • source
  • hideshow 2 child comments
    •
  • [–] 56 points 2 years ago* (last edited 2 years ago) (2 children)

    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.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 4 child comments
    •
  • [–] 25 points 2 years ago* (2 children)

    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)!

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 4 child comments
    •
  • [–] [S] 14 points 2 years 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.

  • permalink
  • fedilink
  • source
  • parent
  • [–] 3 points 2 years ago (1 child)

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

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 2 child comments
    •