Comment on Real Struggle 😔
Dave@lemmy.nz 1 month agoAhhh, 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.
deo@lemmy.dbzer0.com 1 month ago
Nope. Still an excel problem. Why should changing a display option alter the underlying data on export?
Dave@lemmy.nz 1 month ago
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.