Either use event code to timestamp a static date/time into the cell(s) or just
hit CTRL + ; to enter a static date.

CTRL + SHIFT + ; to enter the time.

CTRL + ;<spaceCTRL + SHIFT + ; to enter date and time.

JE has pointed you towards the event code.


Gord Dibben MS Excel MVP


On Sat, 28 Apr 2007 15:28:03 -0700, papakfl
wrote:

Essentially, I want to date and timestamp an entry in a spreadsheet. So, I
want to copy the date and time from the @now() function as a value only.
That is, they won't change for a specific entry the next time I use the
spreadsheeet and make an entry.