Text and dates into one cell without loosing date format
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.
|