Keeping date in the same format

[Ged Traynor]

Hi all

I want to concatenate two columns together, one has the day of the week and the other has a date in date format
When I try the following formula it converts the date to text

Example
A1 has Mon in it
B1 has 13/06/2011

A1&""&B1 what I get is Mon40707
The result I would like to get is Mon 13/06/2011

Is this possible

Thanks in Advance
Ged

 

[VoG]

Try

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

 

[Ged Traynor]

Exactly what I wanted thanks very much

 

[VoG]

No problem. This will also work

=TEXT(B1,"dddd dd/mm/yyyy")