Convert Date Value to Actual Date

Is there a function that will convert a date value i.e. 39063 to the actual date i.e. 12/12/2006. I don't want to format the cell.

In cell 'A1' I have the date (12/12/2006)
In cell 'A2' I have another date (12/11/2007)

In cell 'A4' I have a formula (="Period : "&A1&" to "&A2)
I want it to display like this (Period : 12/12/2006 to 12/11/2007) however it currently displays like this (Period : 39063 to 39398).

Is there a way of formatting just the two dates in the formula to display as dates not date values.

Thanks

Paul

Got it solved now.

If anyone is interested this is the formula I have used:

="Period : "&TEXT(A1,"dd/mm/yyyy")&" to "&TEXT(A2,"dd/mm/yyyy")

Cheers

Paul