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
[–] 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
    •