EXCEL: Convert date value into formatted text

[GaryRW]

I'm trying to include both text and a dates in the same cell. The date just comes up as the date value (eg 37352). Is there a way to format the date without using the cell format (doesn't work) or maybe a way to convert the date to a string?

I'm hoping there's a simple answer that I've missed; all help will be very much appreciated

 

[xlbo]

Gary,
="Blah Blah Blah" & Text(A1,"dd/mm/yy&quot should do the trick (where your date values are in A1)
HTH
Geoff

 

[GaryRW]

Cheers Geoff - easy when you know how