how can I set the concatenate column as a date time column?

[newcryout]

hi guys. I 'm trying to concatenate the date and time together as the
new datetime format. but it seems that the date time cann't be set t
as datetime format. (I change the column's date format , but th
date-time column didn't change according to my selected option) how ca
i set this column. and make the excel take it as a date column?

A2=date
B2=time
date-time=CONCATENATE(TEXT(A2,"MM/DD/YYYY"),TEXT(B2," HH:MM"))

date time date-time
8/29/2009 0:00:00 08-29-2009 00:00:00
8/29/2009 0:15:00 08-29-2009 00:15:00
8/29/2009 0:30:00 08-29-2009 00:30:00
8/29/2009 0:45:00 08-29-2009 00:45:00


Even I 've format the cell in date-time column as date. and select
date type. but the column value didn't change according to my selection

 

[JoAnn Paules]

Try posting your question in an Excel-specific newsgroup rather than an
Office.misc one.