Another one:

=--(B1&C1&A1)

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



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

--

Dave Peterson