Take a look at

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

In article ,
"lost and confused" <lost and
wrote:

I have to use excel to update inventory. I don't know what formula to use.
What I need to have is every time a record is added, a seperate column will
put a time stamp there. I tried useing the NOW() command, but all the
records changed when I added data in a row. Please help.