CONCATENATE with Dates

[BullseyeThor]

I'm tring to create a list that self populates.

I'm using the CONCATENATE formula, but when I use a cell with a date it brings back the number as opposed to the actual date shown.

Is there a way that it can be done so that a date is shown or is this impossible?

I don't really want to use VBA because the workbook is already full of them.

Any help will be much apprieciated.

Thanks

[Ace_XL]

Try something on these lines

=CONCATENATE(TEXT(A1,"dd-mm-yy"),TEXT(B1,"dd-mm-yy"))

[XOR LX]

Hi,

If A1 contains Red and B1 contains 12/03/2013, then:

=A1&TEXT(B1,"dd/mm/yyyy")

will display:

Red12/03/2013

Regards