im trying to concatenate a text and date cell. is this possible?
i.e.
I have one cell that says: Week-ending
And I have another cell: 01/26/2007
Can I concatenate to form: Week-ending 01/26/2007

The problem I have now is the formatting, it keeps taking the date and
making it a number... (you know what I mean?)

Thanks,

Josh