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
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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
