Date Format

[Graham]

I have dates shown as:

A B C

2010 5 Mar

I need them to change to 1 cell in the format 05/03/2010

Can anyone help??
ThanKS
Graham

 

[joel]

I put this formula in column D2. Then format column D in a Date forma
otherwise you will get a number like 40242

=DATEVALUE(C2&" "&B2&", "&A2)

 

[Roger Govier]

Hi Graham

One way
=--(B1&"/"&C1&"/"&A1)

 

[Teethless mama]

=DATE(A1,MONTH(C1&1),B1)

 

[Teethless mama]

Another...

=--(C1&B1&", "&A1)

 

[Dave Peterson]

Another one:

=--(B1&C1&A1)

And give the cell with the formula the format you like (dd/mm/yyyy)