On Feb 7, 1:35 pm, "Bob Phillips" wrote:
=A1&TEXT(A2,"mm/dd/yyyy")

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Yosh" wrote in message

ups.com...



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- Hide quoted text -

- Show quoted text -

sweet.
thanks

another question i have...

how to merge cells conditionally???
is there such a thing as =if(A7=1,A7,MERGE(B1:B7))

Thanks,

JB