concatenate with dates

i want to make a sentance from various cells but the date comes out as a
serial number rather than the dd/mm/yy format I would like.

any ideas?

Use:
="Date is "&TEXT(A1,"dd mmm yyyy")

where cell A1 contains the date

Mangesh

=A1&B1&C1&TEXT(D1,"mm/dd/yyyy")

The formatting within the quotes can be changed..........

Vaya con Dios,
Chuck, CABGx3


"Ciara" <Ciara@discussions.microsoft.com> wrote in message
news:C16FB2BE-A499-4F12-A8EC-11829ED81622@microsoft.com...
> i want to make a sentance from various cells but the date comes out as a
> serial number rather than the dd/mm/yy format I would like.
>
> any ideas?