Hi

Try
=--(C2&"/"&B2&"/"&A2)
Format the cell, FormatCellsNumberCustom dd-mm-yy

--
Regards
Roger Govier

"Totti" wrote in message
...
Hi all i have a sheet with dates of the following form
Year Month Day
1993 May 23
1991 January 28

and i want to gather them into one row instead of three so i want
something of this format

I Wana Get
23-05-93
28-01-91

How is it possible?
Help appreciated