> > Adam Tauno Williams wrote: > > > =DATEVALUE($CELL) will convert a text representation of a date to a date > > > value. > > bg: > > Sounds workable, but where and under what screen am I going to enter it > > in order to apply it to all 678 rows in that column? I tried entering it > > in the edit window on the first one, and got #NAME? as a response.
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 -- *********************************************************************** 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. *********************************************************************** --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
