Help with Concatenation

[alex]

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

 

[Guest]

try

=Text(i34,"dd-mmm-yy")&" and "&text(j34,"dd-mmm-yy")

 

[Guest]

=TEXT(I34,"dd-mmm-yy") & " and " & TEXT(J34,"dd-mmm-yy")

 

[alex]

try

=Text(i34,"dd-mmm-yy")&" and "&text(j34,"dd-mmm-yy")








- Show quoted text -

Thank you both for your help; it worked!

alex