MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Richard on February 21, 2001 10:01 AM

I am trying to concatenate data from two different columns, but can't get my dates to display correctly. I know that dates are represented by actual numberical values, but I was wondering if there was a way to combine these cells (one text and one a date) so that I can read the text and have the date in the correct format.

Thanks for your help,

Posted by cpod on February 21, 2001 10:17 AM

You can do something like:

= "your text " & text(date,"m.d/yy")

This then becomes a text string and is not longer treated as a date.