this post was submitted on 05 Feb 2026
605 points (99.0% liked)
Memes
14617 readers
1731 users here now
Post memes here.
A meme is an idea, behavior, or style that spreads by means of imitation from person to person within a culture and often carries symbolic meaning representing a particular phenomenon or theme.
An Internet meme or meme, is a cultural item that is spread via the Internet, often through social media platforms. The name is by the concept of memes proposed by Richard Dawkins in 1972. Internet memes can take various forms, such as images, videos, GIFs, and various other viral sensations.
- Wait at least 2 months before reposting
- No explicitly political content (about political figures, political events, elections and so on), !politicalmemes@lemmy.ca can be better place for that
- Use NSFW marking accordingly
Laittakaa meemejä tänne.
- Odota ainakin 2 kuukautta ennen meemin postaamista uudelleen
- Ei selkeän poliittista sisältöä (poliitikoista, poliittisista tapahtumista, vaaleista jne) parempi paikka esim. !politicalmemes@lemmy.ca
- Merkitse K18-sisältö tarpeen mukaan
founded 3 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Considering it is being saved in another format, I'd hardly consider this an excel problem.
CSV has existed since before personal computers, much less Microsoft office.
Maybe, by why wouldn't Excel let uou increase the number of digits in a CSV? The data is currently in Excel, and more digits isn't incompatible with the CSV format.
Because it's basically a text file. The data doesn't exist anymore once you open it as a CSV on another computer. It'd basically just add zeros to the end.
They could probably get that info from the other file, but that would mean getting that person to give it to you again.
Yeah thanks, I didn't understand the original problem but I've got it now 🙂
You can't increase the decimal precision beyond the limits of the available data which I think is what OP's coworker wasn't understanding -- unless I'm the one who misunderstood.
The coworker rounded the numerical data during the conversion from xlsx to csv meaning there was less data in the exported csv than in the original Excel file. They seemed to think the data did still exist in the csv but it was being hidden and that they could simply change the precision to unhide it.
Ahhh, the excel format keeps the precision but changes the display to 1 decimal. When exported to CSV, only that 1 decimal is exported, so you can't bring back what isn't there. But the original file still has it.
I understand now, thanks! Definitely a coworker problem not an Excel problem then.
Nope. Still an excel problem. Why should changing a display option alter the underlying data on export?
Well, that's a good point. However, if I wanted to export a CSV with only one decimal place, it would be mighty annoying if changing it to one in Excel didn't save it like that in the CSV. Unless there was another option to control that.