Comment on Real Struggle đ
Dave@lemmy.nz â¨4⊠â¨days⊠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 â¨3⊠â¨days⊠ago
Nope. Still an excel problem. Why should changing a display option alter the underlying data on export?
Dave@lemmy.nz â¨3⊠â¨days⊠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.