You don't really need the TEXT function call; this seems to work as well...

=SUBSTITUTE(A1,".","-")+B1

--
Rick (MVP - Excel)


"Teethless mama" wrote in message
...
=TEXT(SUBSTITUTE(A1,".",""),"00-00-0000")+B1


"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