combing dates and times

Hi,

I have a few columns that i need to combine into one cell.

Column A is names. Column B is a date. Column C is a time

I need to have A1&B1&C1 so they all appear in the same cell.

Problem is, that due to formatting, the date comes out at 39356 and the time appears as 0.41666565623536

I need the date and time to be formatted the same as they are in the previous cell.

Any ideas?

All help is much appreciated.

use this

=CONCATENATE(A1,B1,C1)

that should work fine buddy

Actually you obviuously tried that and as i did to check i works and hey presto it doesn't!! doh!! sorry to waste your time.