• 0 Posts
  • 6 Comments
Joined 2 years ago
cake
Cake day: July 1st, 2023

help-circle

  • pajam@lemmy.worldtoEngineering Memes@lemmy.worldGet Dated
    link
    fedilink
    English
    arrow-up
    3
    ·
    19 days 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.