• MelodiousFunk@kbin.social
    link
    fedilink
    arrow-up
    117
    arrow-down
    1
    ·
    8 months ago

    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.

    • TwinHaelix@reddthat.com
      link
      fedilink
      English
      arrow-up
      13
      ·
      8 months 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.