Convert ExcelData To A Different Format

[CARBOB]

I would like a formula if possible that will put the data in Col's A,B,C,D in the same format as the data in Col E. Another software I have uses the same format as Col E. I would then be able to import the data. Is there a way to do this? Appreciate all suggestions. Thanks.

Book1
	A	B	C	D	E
1	date	P1	P2	P3
2	10/05/05	6	7	6	10/05/2005;6;7;6
3	10/05/05	1	1	1	10/05/2005;1;1;1
4	10/05/05	0	2	1
5	10/05/05	6	4	2
6	10/05/05	5	4	4
7	10/05/05	5	3	3
8	10/05/05	3	3	7
9	10/05/05	8	1	0
10	10/05/05	4	2	3
draw

 

[Datsmart]

Try this:

=TEXT(A2,"mm/dd/yyyy")&";"&B2&";"&C2&";"&D2

 

[CARBOB]

VERY GOOD, THANKS.