Hi, I am working with Excel 2003 and have a ws that I need to combine column
B which is a date, with column C which contains the time. No matter how I
have formatted column D, I cannot get the date to display correctly.

What I have is: B C
05/01/2010 10:55
24/12/2009 09:35

I need column D to show as: 05/01/2010 10:55
24/12/2009 09:35

I have tried several different formulas/formatting in Column D but always
end up with the result in Column D as: 40183 10:55
40171 09:35

I am hoping someone can help solve my problem.

Many Thanks




--
Linda