Microsoft Fixes Excel Feature That Forced Scientists to Rename Human Genes::Microsoft now allows users to disable automatic date conversion, which means scientists no longer have to worry about using alternative names for genes.

  • Poach@lemmy.world
    link
    fedilink
    English
    arrow-up
    25
    ·
    edit-2
    1 year ago

    Microsoft fixed something and made their products better!? I don’t believe you.

    I wonder if this will fix any of my issues with excel molesting my data. It will either round my part numbers from a BoM making it useless or removing preceding zeros which breaks our inventory importing.

    • Mr_Dr_Oink@lemmy.world
      link
      fedilink
      English
      arrow-up
      1
      arrow-down
      1
      ·
      1 year ago

      So did i. Format cell(s) > data type (or something) then just seleect text, or custom or whatever.

  • Pretty Sure Not a Bot@lemmy.world
    link
    fedilink
    English
    arrow-up
    13
    ·
    1 year ago

    Omfg! The amount of time I screamed at Microsoft because I keep forgetting that excel changes the date format for some fucking reason and doesn’t tell you!

  • Magister@lemmy.world
    link
    fedilink
    English
    arrow-up
    7
    ·
    1 year ago

    I worked in a company where excel files were used as a database and then read through JavaScript to be processed…

  • MirthfulAlembic@lemmy.world
    link
    fedilink
    English
    arrow-up
    4
    ·
    1 year ago

    Took long enough. Now let’s see if they can give an option to turn off Lotus 1-2-3 compatibility stuff like single quotes starting a cell being hidden as markup.