Is there any way I can populate the column AV in my spreadsheet with the Date
and Time once a value has been entered in column AV and keep this original
value. Can I protect this original value from being changed?

I can insert the date and time wiht the Now() function but this updates so
does not serve our purpose.
Thanks heaps