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

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

Vaya con Dios,
Chuck, CABGx3


"Ciara" wrote in message
...
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?