Hello all,

I'm trying to concatenate two cells with dates.
The concatenation works; however, the dates change formats.

Formula: =concatenate(i34," and ",j34)
Result: 38596 and 39325
What I want: 01-SEP-05 and 31-AUG-07

I'm assuming I need to wrap the concatenating cells in some type of
date format.
Modifying the destination cell; e.g., changing it to a date format,
does not work.

Thoughts?

alex