Joining cells with date returning a number?

[Zeldaa]

Hi,

I'm having bit of an issue here, in cell A1 I have text, then in B1 a date in dd/mm/yyyy format, then in C1 text and date in the same format in D1.

When I join the cells i.e =A1&B1&C1&D1 it returns a number for the date? I have tried to change the date to a number format and then changed the formula cell to a date format but it still doesnt work.

Any ideas?

 

[VoG]

Hi. Try

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

 

[Zeldaa]

Thanks a million mate!