677
Get Dated (lemmynsfw.com)
submitted 6 months ago* (last edited 6 months ago) by [email protected] to c/[email protected]
you are viewing a single comment's thread
view the rest of the comments
[-] [email protected] 3 points 6 months 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.

[-] [email protected] 3 points 6 months 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.

this post was submitted on 16 Jan 2025
677 points (100.0% liked)

Engineering Memes

1696 readers
1 users here now

About:

Memes about engineering for all disciplines.

Rules:

General Rules:

  1. No hate speech
  2. No harassment, calls to violence
  3. No advertisement

Posts:

  1. Must be a meme/joke/observation/attempt at humour
  2. Must be engineering related (software engineer humour probably better suited for programmer humour communities, though not explicitly banned)

founded 2 years ago
MODERATORS