Need to store the Date & Time whenever a value is entered to a cell.
If a value is entered to celle B3 then the current date & time should be
saved in C3.

I used the following in cell C3

=IF(B3<"", NOW()," " )

But whenever any operation is done in a cell the Date & Time gets the
current value which I dont want to happen.

Thanks Asoka