formula for date conversion

[wellhard]

Hi
Does anybody have a formula to convert this date.

<TABLE style="WIDTH: 96pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=128><COLGROUP><COL style="WIDTH: 96pt; mso-width-source: userset; mso-width-alt: 4681" width=128><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 96pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 height=20 width=128>2011-03-26 00:00:00

to normal format 26/03/2011.

Thanks

</TD></TR></TBODY></TABLE>

 

[VoG]

Hi. try like this

=DATE(LEFT(A1,4),MID(A1,6,2),MID(A1,9,2))

 

[Mike Blackman]

Hi,

For a one off formula this;

=DATE(LEFT(A1,4),MID(A1,6,2),MID(A1,9,2))

Else, if you have a full column of these dates you may want to use Text To Columns - Fixed Witdh - YY-MM-DD to convert them all in one hit.

 

[wellhard]

Cheers, exactly what i need