• FurtiveFugitive@lemm.ee
    link
    fedilink
    English
    arrow-up
    3
    ·
    8 hours ago

    This but with goddamn scientific notation.

    That and sometimes the answer to fixing it is simply selecting the cell, not changing a thing, and hitting enter.

    • pajam@lemmy.world
      link
      fedilink
      English
      arrow-up
      2
      ·
      7 hours ago

      Yep, I hate that Excel doesn’t open CSV files and treat every cell as “Text” considering that’s how a CSV stores the data. It loves to convert to scientific notation, or omit leading zeros, or omit trailing zeros on a decimal, or assume something is a date. I always have to update csv files to .txt instead and then import it via the wizard and manually select Text for all columns.