In a 4th cell put

=DATE(A9,A8,A7)

Don't know if I got the order right for A7 and A8

it should be

-DATE(year,month,day)


--

Regards,

Peo Sjoblom

"Al" wrote in message
...
I have inherited a spreadsheet that contains columns of numbers to
represent
a day (dd), columns with numbers for month (mm) and another with the year
(yyyy)

How can I combine the 3 cells in a row to produce a date cell
(dd/mm/yyyy)?

e.g.
A7 = 7
A8 = 5
A9 = 2001
but I need 07/05/2001