Hello All,

Thank you for your solutions, but unfortunately neither of the solutions
worked. the error iam getting is mainly because of the regional and langauge
settings, 01.03.2009 is the date format of switzerland and my PC is with US
settings, so I changed the regional settings and the formula worked out well.

Thanks again for ur quick response.

Anil

"Anil123" wrote:

Hi,

Iam trying to add date column ( 01.03.2009) and time column (23:30:00) to a
single cell to get the result as 2/28/2009 23:30 using the formula :

=IF(A1<"",A1+B1,""), But its throwing an exception of #VALUE!

Please help in this regard.

Thanks,
Anil