Or, simpler,

="Heading test"&TEXT(A1,"dd/mm/yyyy")

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]


On Mon, 21 Dec 2009 12:20:01 -0800, cm
wrote:

assuming your date is in cell A1:

="heading text "&DAY(A1)&"/"&MONTH(A1)&"/"&YEAR(A1)