Comment on Microsoft fixes the Excel feature that was wrecking scientific data

macrocephalic@lemmy.world ⁨1⁩ ⁨year⁩ ago

• theparadox@lemmy.world ⁨1⁩ ⁨year⁩ ago

  Now if only it would stop dropping leading zeros unless you ask it

  That appears to actually be a feature. Image

  source

  • macrocephalic@lemmy.world ⁨1⁩ ⁨year⁩ ago

    Holy shit! Now I just need to talk to some sysadmins and get some group policies set.

    source

    • theparadox@lemmy.world ⁨1⁩ ⁨year⁩ ago

      Apparently our typical installer for Visio 2016 and our 365 license use" incompatible installers" so it is going to be a pain in the ass for me to have both installed at the same time. Thankfully I’m trusted by IT so I might be able to just do it myself.

      source
• Etterra@lemmy.world ⁨1⁩ ⁨year⁩ ago

  MM/DD/YYYY is the correct format here in America.

  source

  • EngineerGaming@feddit.nl ⁨1⁩ ⁨year⁩ ago

    I think the point was that the format itself is odd. I am European and it’s weird to me: logically it should be either from greatest to smallest, or from smallest to greatest, not a weird in-between.

    source

    • atzanteol@sh.itjust.works ⁨1⁩ ⁨year⁩ ago

      Logically it would be milliseconds since 1970.

      source

      • macrocephalic@lemmy.world ⁨1⁩ ⁨year⁩ ago

        Not very good for birthdates.

        source