On Thu, 24 Jul 2003 15:38:03 -0400, "JC Home" wrote:

I would like to have a cell enter the current date when I make an entry in
another cell, but I would like it to be static. The today() and now() both
seem to be volatile. I know that I could use cntl ; but I would like it
to be entered automatically.

Thanks

Record a macro where you type =now()into any blank cell, copy,
paste-special/value. Anywhere you want to insert a static date, select that
cell and run the macro. Assigning that mcro to a key combination makes it
really easy to use.