How can I put text and dates into one cell without loosing the date format.
I can use & and concatenate but the date format always gets lost.

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

A1=Text
B1=Date (in DD/MM/YYYY or other Date format)

HTH

"Hazeltine" wrote:

How can I put text and dates into one cell without loosing the date format.
I can use & and concatenate but the date format always gets lost.

Here's a guess at what you might need...

For A1: (a date)
B1: ="This is my date: "&TEXT(A1,"mm/dd/yyy")

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Hazeltine" wrote:

How can I put text and dates into one cell without loosing the date format.
I can use & and concatenate but the date format always gets lost.