Quote:
Originally Posted by Ripplinger
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.
|
No, it wasn't showing invalid like ###### (or whatever LO would show in that case), but was interpreting the numbers as text and no amount of reformatting the cells would cause them to be numbers. If you copied the text you could see that it was interpreting them as '$25.14 (with the tickmark to indicate the literal string).