Quote:
Originally Posted by twowheels
I also used LibreOffice [OpenOffice]. It doesn't open the csv file correctly by default and sees the numbers as text, so it doesn't try to sum them. I had to re-paste the values as plan text to force it to see them correctly.
|
Usually that happens when the columns are too narrow to display the entire test within, and csv files won't save your column spacing to prevent that from happening each time you open the file. I usually resave it as an excel file, adjust my columns and resave and then the column width stays and the numbers turn into real dates as they should.