> > 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 > >> > > > > bg: > > > > Doesn't work. Whether I enter it as =DATEVALUE($CELL) > > or as =DATEVALUE($THEDATECELL) it still echoes " #NAME? " > > all the way through to the final paste. What am I doing wrong? > > > > Brewster > > 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 -- *********************************************************************** Embrace a sharing community of sustainable justice low-carbon diversity *********************************************************************** W. Brewster Gillett [email protected] Portland, OR USA *********************************************************************** Simply because you don't like to hear it, that doesn't make it untrue. ***********************************************************************
sampleCalcOOusers.ods
Description: application/vnd.oasis.opendocument.spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
