Hi Tommo,

That's because the NOW() function is volatile so it will update
everytime you enter anything on the sheet.

Have a look at this site for info on time stamps

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

HTH
Martin