Hi all,

is it possible to format an excel cell with a text and a date in the
same cell ?

eg :

In A1 I've a text cell : "360 :"
In A2 I've a date formated in ddmmyy
In A3 I've a text cell :"zzzzzzz"

In A4 I would like to concatenate all the cells but I've the following
result : "360:38895zzzzzzz" instead of "360:ddmmyyzzzzzzz" where 38895
is the excel date.

Thank you

Nic