Hi All

Excel is not pulling the date in proper format while applying the date cell
in a formula.
ER:
ColumnA ColumnB ColumnC
Amount Date Settled
250 4/9/2008 Amount 250 Settled on 39547

Column C formula is =CONCATENATE("Amount"," ",A2," ","Settled on ",B2)

I need date 04/09/08 in C column not 39547. Formula should give me Amount
250 settled on 04/09/08.

Is there any function to resolve this?

Thanks in advance.