Try these:

Put this in a cell:
=A3
And format the cell
dd/mm/yy

OR
Put this in a cell:
=TEXT(A3,"dd/mm/yy")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"gb_S49" wrote in 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?