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
[–] 45 points 2 years ago* (1 child)

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

  • permalink
  • fedilink
  • source
  • hideshow 2 child comments
    •
  • [–] 18 points 2 years ago (1 child)

    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...

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