ExcelBanter - View Single Post - how do I record the time data is entered into a spreadsheet?

JE McGimpsey

See

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

In article ,
bmk wrote:

I want to record the time and date data is entered into a row on a
spreadsheet and not have it change when more data is added to the next row,
using the =now() formula will update every time data is entered on the next
row, I want each row of data to have a time stamp of when it was first put in.