From: Graham on
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
From: Roger Govier on
Hi Graham

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

Graham wrote:
> 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
From: joel on

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

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


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=198299

http://www.thecodecage.com/forumz

From: Teethless mama on
=DATE(A1,MONTH(C1&1),B1)


"Graham" wrote:

> 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
From: Teethless mama on
Another...

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


"Graham" wrote:

> 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