concatenate with dates

C

Ciara

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?
 
M

mangesh_yadav

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

where cell A1 contains the date

Mangesh
 
C

CLR

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

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

Vaya con Dios,
Chuck, CABGx3
 
Top