assuming your date is in cell A1:

="heading text "&DAY(A1)&"/"&MONTH(A1)&"/"&YEAR(A1)
--
hope to help,
cm


"lightbulb" wrote:

using a formula, I am combining a column heading and the date in that row, so
that the cell will read "Column Heading Date", but the date is showing as a
number rather than a date. I want the cell to contain both txt (column
heading), and a date. How do I format it to do so?