394
Microsoft fixes the Excel feature that was wrecking scientific data (www.theverge.com)
submitted 2 years ago by to c/technology@lemmy.world
86 comments fedilink hide all child comments
you are viewing a single comment's thread
view the rest of the comments
[–] 116 points 2 years ago (2 children)

Me before reading the article: It's got to be dates. Excel thinks everything is a date.

Me after reading the article: Even the workaround is halfhearted. Jeebus.

  • permalink
  • fedilink
  • source
  • hideshow 4 child comments
    •
  • [–] 13 points 2 years ago

    Microsoft’s blog adds caveats, such as that Excel avoids the conversion by saving the data as text, which means the data may not work for calculations later. There’s also a known issue where you can’t disable the conversions when running macros.

  • permalink
  • fedilink
  • source
  • parent