If you want the current date & time in B if A isn't blank, but you want B
blank if A is blank, then you could change your formula to
=IF(A1="","",NOW())
but remember that it will continue to show current date and time each time
you open or update the sheet.

If you want the value frozen at the time A is filled in, then you'll
probably need a VBA solution.
--
David Biddulph

"orquidea" wrote in message
...
Hi

I want a formula which automaticaly types the current date and time when
data have been entered in the cell beside. ie.

A B
DOG =if(A1="",(=NOW()) dd/mm/yy hh:mm

But this one doesn't work.

Could anyone help me please.

Thanks
Orquidea