You need an event macro to do that:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then 'Column A
Range("B" & Target.Row) = Time
End If
End Sub

Post if you need help to install it!

Regards,
Stefi
€žbaha€� ezt Ã*rta:

Hi,
First of all I search for smilar question but could not get any
answer,if this is duplucated question,please accept my appoligies.
I have a spread sheet which looks like a log file.What I want to do
is, when I enter a number in a cell in A coloumn, to display the time
in column B.I tried now,but when the next number entered in column A
it all change the entire colum B.I haveother formulas,so that I cannot
chose manual calculations options.
Thanks for your help.
Baha