Brewster Gillett wrote,
[..]
I'm attaching a stripped-down 200 rows or so of it as a sample.
200 rows gives a fair range of the dates, and of course displays the
evidence that the column is *not* being sorted by date, but as
text numerical data :-)
It's only 22K, so shouldn't have any difficulty getting through...
...thanks for your efforts.
Some, but not all of the dates have leading apostrophes.
I did this:
Open the .ods file in OOo Calc.
File|Save as... and pick .csv format.
Close Calc. When I used a plain text editor, there were no leading
apostrophes in any of the dates.
Find the .csv file you saved.
Right-click|Open in OOo Calc.
You should get presented with an input filter dialog.
Click the column heading for the date column (it will initially say
"Standard"), then just above that is a drop down for "Column type". Pick
"Date (MDY)" (I presume that's how you dates are).
Then the column should import as "proper" dates and you can format
appropriately.
[OOo 3.2.1, Windows]
--
Bob Long
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
