this post was submitted on 16 Jan 2025
644 points (98.2% liked)
Engineering Memes
1365 readers
296 users here now
About:
Memes about engineering for all disciplines.
Rules:
General Rules:
- No hate speech
- No harassment, calls to violence
- No advertisement
Posts:
- Must be a meme/joke/observation/attempt at humour
- Must be engineering related (software engineer humour probably better suited for programmer humour communities, though not explicitly banned)
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
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.
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
.txtinstead and then import it via the wizard and manually select Text for all columns.