Brewster Gillett wrote:
Adam Tauno Williams wrote:
Insert a column
enter =DATEVALUE($THEDATECELL)
copy-and-paste that one cell to the rest of the column
copy the date value column
paste as values over the old column
delete the column you created
Richard Detwiler wrote:
Is there any way you can send a small portion of the file with any
confidential information removed or altered? (or post it on a web site)
I'm not able to recreate the problem you're having, which I suspect is
because I don't have the same type of CSV file that the data originated
from.
bg:
I guess that's possible, although I am working with it saved as
an Open Office .ods file, not in the originally received .csv version.
All I ever do with the .csv versions is strip off the unneeded columns
to make them conform to my template - all further work on them is then
done in the saved-as-.ods version.
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.
Brewster
Brewster: I opened your file, went to cell D2, and entered the formula
=DATEVALUE(C2). It gave me an integer number, 40198, which I knew was
encouraging. Then when I formatted the cell as a date (choosing the
12/31/99 option), it gave me the date 01/20/99, which is what it should be.
Then it's a simple matter of copying cell D2 down through as many rows
as you need.
