Is there a way to time stamp an entry in excel?

[SMEG]

I have tried using an IF() function with a now() as a
false result on a blank cell, however the time changes
whenever another cell using the same formula has data
entered into it... is there another method that want
update successively and without using access?

 

[Frank Kabel]

Hi
see:
http://www.mcgimpsey.com/excel/timestamp.html

 

[Arvi Laanemets]

Hi

Ctrl+";" inserts current system date into cell.
Ctrl+":" inserts current system time into cell.

 

[Don Guillett]

you could use a worksheet_change event macro.
right click sheet tab>view code>insert this>save
now when you enter anything in col B below row 1 the date will be put in col
C

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo fixit
If Target.Row < 2 And Target.Column <> 2 Then Exit Sub
Application.EnableEvents = False
Target.Offset(, 1) = Date
fixit:
Application.EnableEvents = True
End Sub