On 9/22/2010 7:17 PM, Brewster Gillett wrote:
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
Try substituting the actual cell reference in place of "THEDATECELL"
eg; =DATEVALUE($E5) where cell E5 is the cell that contains the date.
Gene
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
