Help with Concatenation
 

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

Help with Concatenation
 

try

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



"alex" wrote:

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

Help with Concatenation
 

=TEXT(I34,"dd-mmm-yy") & " and " & TEXT(J34,"dd-mmm-yy")
--
Gary''s Student - gsnu200740

Help with Concatenation
 

On Aug 28, 8:42 am, Duke Carey
wrote:
try

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



"alex" wrote:
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- Hide quoted text -

- Show quoted text -

Thank you both for your help; it worked!

alex