Gary
You'll need an event macro to do that. Something like:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count 1 Or Target = "" Then Exit Sub
If Target.Column = 2 Then Target.Offset(, -1) = Now
End Sub

Watch out for line wrap in this message. Expand this message to see the
code properly. Right-click on the sheet tab, select View Code, and paste
this macro in that module. HTH Otto
"GaryByrd" wrote in message
...
I am trying to use Excel sorta like a database. When I enter data into a
cell
such as B1 I want A1 to stamp the date and time.