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