Jason, It works.
That's brilliant.
THANK YOU
What does int mean though

"Jason Morin" wrote:

Use

=INT(A3)

if it truly is a date, and format the cell as date. If
it's a text string, try:

=LEFT(A3,FIND(" ",A3)-1)+0

HTH
Jason
Atlanta, GA

-----Original Message-----
I am trying to extract just the date aspect of the
following (text?) (cell A3)
30/03/2005 14:17:00. using =DATEVALUE(MID(A3,0,10))
all i get #value
any suggestions?
.