you are viewing a single comment's thread
view the rest of the comments
[–] 5 points 7 months ago (2 children)

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.

  • source
  • parent
  • hideshow 2 child comments
  • [–] 4 points 7 months ago (1 child)

    Nope. Still an excel problem. Why should changing a display option alter the underlying data on export?

  • source
  • parent
  • hideshow 1 child comment
  • [–] 3 points 7 months 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.

  • source
  • parent